Query Metrics
50
Database Queries
16
Different statements
1605.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1386.31 ms (86.35%) |
1 |
SELECT t0.id AS id_1, t0.shipping_value AS shipping_value_2, t0.shipping AS shipping_3, t0.comment AS comment_4, t0.transaction_code AS transaction_code_5, t0.payment_link AS payment_link_6, t0.payment_gateway AS payment_gateway_7, t0.order_value AS order_value_8, t0.cep AS cep_9, t0.address AS address_10, t0.address_number AS address_number_11, t0.address_complement AS address_complement_12, t0.session AS session_13, t0.ip AS ip_14, t0.browser AS browser_15, t0.cpf AS cpf_16, t0.phone AS phone_17, t0.installments AS installments_18, t0.installment_value AS installment_value_19, t0.city AS city_20, t0.state AS state_21, t0.status AS status_22, t0.purchase_date AS purchase_date_23, t0.name AS name_24, t0.district AS district_25, t0.purchase_code AS purchase_code_26, t0.recipient_name AS recipient_name_27, t0.extra_info AS extra_info_28, t0.billing_cep AS billing_cep_29, t0.billing_address AS billing_address_30, t0.billing_address_number AS billing_address_number_31, t0.billing_address_complement AS billing_address_complement_32, t0.billing_district AS billing_district_33, t0.billing_city AS billing_city_34, t0.billing_state AS billing_state_35, t0.invoice AS invoice_36, t0.invoice_image_kit_id AS invoice_image_kit_id_37, t0.payment_method AS payment_method_38, t0.tracking_code AS tracking_code_39, t0.store_id AS store_id_40, t0.buyer_id AS buyer_id_41 FROM purchase t0 WHERE t0.session = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
"6960d832747221767954482"
]
|
|
64.53 ms (4.02%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.name = ? AND t0.store_id = ? LIMIT 1
Parameters:
[ "google_analytics" 1 ] |
|
34.10 ms (2.12%) |
8 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.image_kit_id AS image_kit_id_3, b0_.url AS url_4, b0_.target AS target_5, b0_.type AS type_6, b0_.store_id AS store_id_7 FROM store s1_, banner b0_ WHERE b0_.type = ? AND b0_.store_id = ?
Parameters:
[ 2 1 ] |
|
23.88 ms (1.49%) |
3 |
"COMMIT"
Parameters:
[] |
|
13.32 ms (0.83%) |
2 |
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.store_id = ? LIMIT 1 OFFSET 999
Parameters:
[ 1 1 ] |
|
13.32 ms (0.83%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
12.00 ms (0.75%) |
1 |
INSERT INTO purchase (shipping_value, shipping, comment, transaction_code, payment_link, payment_gateway, order_value, cep, address, address_number, address_complement, session, ip, browser, cpf, phone, installments, installment_value, city, state, status, purchase_date, name, district, purchase_code, recipient_name, extra_info, billing_cep, billing_address, billing_address_number, billing_address_complement, billing_district, billing_city, billing_state, invoice, invoice_image_kit_id, payment_method, tracking_code, store_id, buyer_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null null null null null null null null null null "6960d832747221767954482" "216.73.216.220" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" null null null null null null 7 "2026-01-09 07:28:03" null null null null null null null null null null null null null null null null 1 null ] |
|
11.72 ms (0.73%) |
2 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.free_shipping AS free_shipping_2, p0_.slug AS slug_3, p0_.status AS status_4, p0_.gtin AS gtin_5, p0_.description AS description_6, p0_.weight AS weight_7, p0_.height AS height_8, p0_.width AS width_9, p0_.depth AS depth_10, p0_.sku AS sku_11, p0_.store_id AS store_id_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14, p0_.brand_id AS brand_id_15 FROM product p0_ INNER JOIN product_variation p1_ WHERE p1_.product_id = p0_.id AND p0_.store_id = ? AND p1_.stock > 0 AND p0_.status = ? GROUP BY p0_.id LIMIT 25
Parameters:
[ 1 1 ] |
|
8.26 ms (0.51%) |
2 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.bottom_menu AS bottom_menu_3, b0_.store_id AS store_id_4 FROM brand b0_ WHERE b0_.bottom_menu = 1 AND b0_.store_id = ? ORDER BY b0_.name ASC
Parameters:
[
1
]
|
|
8.11 ms (0.51%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.store_id AS store_id_4 FROM configuration t0 WHERE t0.store_id = ?
Parameters:
[
1
]
|
|
7.92 ms (0.49%) |
1 |
UPDATE purchase_product SET quantity = ? WHERE id = ?
Parameters:
[ 1 83580 ] |
|
6.72 ms (0.42%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_from AS price_from_4, t0.stock AS stock_5, t0.status AS status_6, t0.image AS image_7, t0.image_kit_id AS image_kit_id_8, t0.gtin AS gtin_9, t0.sku AS sku_10, t0.product_id AS product_id_11 FROM product_variation t0 WHERE t0.id = ?
Parameters:
[
"2245"
]
|
|
6.40 ms (0.40%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.cep AS cep_4, t0.creation_time AS creation_time_5, t0.description AS description_6, t0.status AS status_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.shipping AS shipping_10, t0.payment_gateway AS payment_gateway_11, t0.free_shipping AS free_shipping_12, t0.phone AS phone_13, t0.address_full AS address_full_14, t0.public_email AS public_email_15, t0.cnpj AS cnpj_16, t0.ie AS ie_17, t0.color_one AS color_one_18, t0.w_frete_token AS w_frete_token_19, t0.plan_id AS plan_id_20 FROM store t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"chupetao.com.br"
]
|
|
4.19 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.product_limit AS product_limit_2, t0.sale_fee AS sale_fee_3, t0.price_monthly AS price_monthly_4, t0.title AS title_5, t0.integrations AS integrations_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
3.45 ms (0.21%) |
1 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.product_name AS product_name_4, t0.product_variation_id AS product_variation_id_5, t0.purchase_id AS purchase_id_6 FROM purchase_product t0 WHERE t0.product_variation_id = ? AND t0.purchase_id = ? LIMIT 1
Parameters:
[ 2245 73144 ] |
|
1.16 ms (0.07%) |
1 |
INSERT INTO purchase_product (quantity, price, product_name, product_variation_id, purchase_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 0 253.89 "Boneca Cry Babies Lena - Multikids - - V1" 2245 73144 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Store | No errors. |
| App\Entity\Plan | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Purchase | No errors. |
| App\Entity\Configuration | No errors. |
| App\Entity\StorePayment | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\StoreFaq | No errors. |
| App\Entity\NewsLetter | No errors. |
| App\Entity\ExceptionLog | No errors. |
| App\Entity\StoreStatusLog | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\ProductVariation | No errors. |
| App\Entity\SubCategory | No errors. |
| App\Entity\ProductAttribute | No errors. |
| App\Entity\ProductImages | No errors. |
| App\Entity\PurchaseProduct | No errors. |
| App\Entity\PurchaseLog | No errors. |