POST https://app103.fr/_components/offer_table/columnSort

Query Metrics

9 Database Queries
9 Different statements
25.45 ms Query time
0 Invalid entities
11 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.62 ms
(37.81%)
1
SELECT DISTINCT o0_.id AS id_0, o0_.last_update AS last_update_1 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = ? AND p5_.uuid = ? AND o0_.vintage = ? AND e3_.status = ? AND o0_.status = 1 AND o0_.qty > 0 ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e3_.id = e6_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC LIMIT 50
Parameters:
[
  0
  "cd64e941-2745-492a-96bd-c1830bd99cab"
  2020
  1
]
9.35 ms
(36.75%)
1
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = ? AND p5_.uuid = ? AND o0_.vintage = ? AND e3_.status = ? AND o0_.status = 1 AND o0_.qty > 0
Parameters:
[
  0
  "cd64e941-2745-492a-96bd-c1830bd99cab"
  2020
  1
]
2.78 ms
(10.93%)
1
SELECT o0_.id AS id_0, e1_.id AS id_1, CASE WHEN e1_.display_name IS NOT NULL AND e1_.display_name <> '' THEN e1_.display_name ELSE e1_.name END AS sclr_2, CASE WHEN o0_.import_process_id = 1 THEN 'manual' ELSE 'import' END AS sclr_3, CASE WHEN o2_.id IS NOT NULL THEN 1 ELSE 0 END AS sclr_4, e1_.code AS code_5, o0_.id AS id_6, o0_.uuid AS uuid_7, o0_.type AS type_8, o0_.vintage AS vintage_9, o0_.packaging_flat AS packaging_flat_10, o0_.packaging_value AS packaging_value_11, o0_.is_flat AS is_flat_12, o0_.format_filled AS format_filled_13, o0_.type AS type_14, p3_.uuid AS uuid_15, p3_.name AS name_16, p3_.display_name AS display_name_17, p3_.code AS code_18, e4_.id AS id_19, o0_.category AS category_20, p5_.name AS name_21, p5_.code AS code_22, p6_.name AS name_23, o0_.qty AS qty_24, o0_.price AS price_25, o0_.last_update AS last_update_26, o0_.unoficial_qty AS unoficial_qty_27, o0_.unoficial_price AS unoficial_price_28, o0_.unoficial_update AS unoficial_update_29, o0_.status AS status_30, o0_.created_by_name AS created_by_name_31, o0_.comment AS comment_32, o0_.status AS status_33, e1_.provisioning AS provisioning_34, p7_.price AS price_35, p7_.recommended_price AS recommended_price_36, e1_.offer_type AS offer_type_37 FROM offer o0_ LEFT JOIN product_format p5_ ON o0_.format_id = p5_.id LEFT JOIN product_packaging p6_ ON o0_.packaging_id = p6_.id LEFT JOIN entity e1_ ON o0_.entity_id = e1_.id LEFT JOIN offer_favourite o2_ ON (o2_.offer_id = o0_.id) LEFT JOIN product p3_ ON o0_.product_id = p3_.id LEFT JOIN entity e4_ ON p3_.entity_id = e4_.id LEFT JOIN product_vintage p7_ ON p3_.id = p7_.product_id AND (p7_.product_id = p3_.id AND p7_.year = o0_.vintage) WHERE (((e1_.id <> e4_.id OR (e1_.id = e4_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e1_.ignore_import = ? AND p3_.uuid = ? AND o0_.vintage = ? AND e1_.status = ? AND o0_.status = 1 AND o0_.qty > 0 AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e1_.id = e4_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC
Parameters:
[
  0
  "cd64e941-2745-492a-96bd-c1830bd99cab"
  2020
  1
  208594
  26335
  224193
  246593
  176917
  14426
  30986
  140025
  9219
  9220
  76948
  244477
  3708
  169786
  102284
  94580
  51510
  129338
  20288
  20289
  194002
  19196
  75212
  75887
  154868
  15074
  129339
  103129
  3710
  154867
  162588
  224192
  76949
  224191
  224190
  15075
  15076
]
1.16 ms
(4.57%)
1
"COMMIT"
Parameters:
[]
0.68 ms
(2.69%)
1
SELECT * 
            FROM offer_history oh
            WHERE oh.offer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  208594
  26335
  224193
  246593
  176917
  14426
  30986
  9219
  140025
  9220
  76948
  244477
  3708
  169786
  102284
  94580
  51510
  129338
  20288
  20289
  194002
  19196
  75212
  75887
  154868
  15074
  129339
  103129
  3710
  154867
  162588
  224192
  76949
  224191
  224190
  15075
  15076
]
0.60 ms
(2.36%)
1
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
  16
]
0.59 ms
(2.32%)
1
SELECT t0.code AS code_1, t0.display_name AS display_name_2, t0.lwin AS lwin_3, t0.site AS site_4, t0.seller_price_qty AS seller_price_qty_5, t0.price AS price_6, t0.merged_uuids AS merged_uuids_7, t0.has_lwin_suggests AS has_lwin_suggests_8, t0.from_import AS from_import_9, t0.bundle AS bundle_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.name AS name_13, t0.status AS status_14, t0.country_id AS country_id_15, t0.region_id AS region_id_16, t0.sub_region_id AS sub_region_id_17, t0.color_id AS color_id_18, t0.type_id AS type_id_19, t0.sub_type_id AS sub_type_id_20, t0.entity_id AS entity_id_21, t0.classification_id AS classification_id_22, t0.line_id AS line_id_23, t0.producer_id AS producer_id_24 FROM product t0 WHERE t0.id = ?
Parameters:
[
  13
]
0.46 ms
(1.81%)
1
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[
  "2025-07-07 09:34:16"
  16
]
0.20 ms
(0.77%)
1
"START TRANSACTION"
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Company 1
App\Entity\Product\Product 1
App\Entity\Country 1
App\Entity\Region 1
App\Entity\Product\Color 1
App\Entity\Product\Type 1
App\Entity\Property\Property 1
App\Entity\Product\Classification 1
App\Entity\Product\Line 1
App\Entity\Property\Producer 1