Query Metrics

26 Database Queries
14 Different statements
20.84 ms Query time
1 Invalid entities
1 Managed entities

Queries

Group similar statements

pim connection

# Time Info
1 3.10 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 12 OFFSET 36
Parameters:
[
  "fraises"
]
2 0.50 ms
SELECT * FROM product_image WHERE product_id IN (?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY is_primary DESC, sort_order ASC
Parameters:
[
  22
  21
  23
  27
  39
  37
  38
  48
  49
  50
  65
  66
]
3 0.68 ms
SELECT COUNT(*) FROM product p LEFT JOIN universe u ON p.universe_id = u.id WHERE p.is_active = true AND u.slug = ?
Parameters:
[
  "fraises"
]
4 0.24 ms
SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC
Parameters:
[]
5 0.65 ms
SELECT c.*,
           u.name as universe_name,
           u.slug as universe_slug,
           p.name as parent_name
    FROM category c
    LEFT JOIN universe u ON c.universe_id = u.id
    LEFT JOIN category p ON c.parent_id = p.id
    WHERE c.is_active = true
    ORDER BY c.sort_order ASC, c.name ASC
Parameters:
[]
6 0.55 ms
SELECT uc.*
    FROM universe_characteristic uc
    JOIN universe u ON uc.universe_id = u.id
    WHERE u.slug = ?
    ORDER BY uc.sort_order ASC
Parameters:
[
  "fraises"
]
7 1.17 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
8 0.97 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
9 0.95 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
10 0.93 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
11 1.21 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
12 0.86 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
13 1.37 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
14 1.34 ms
SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true AND u.slug = ?
    ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
  "fraises"
]
15 0.25 ms
SELECT u.*
    FROM universe u
    WHERE u.slug = ?
Parameters:
[
  "fraises"
]
16 0.22 ms
SELECT u.*
    FROM universe u
    WHERE u.slug = ?
Parameters:
[
  "fraises"
]
17 0.21 ms
SELECT u.*
    FROM universe u
    WHERE u.slug = ?
Parameters:
[
  "fraises"
]
18 0.26 ms
SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC
Parameters:
[]

default connection

# Time Info
1 0.87 ms
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = ? AND c0_.user_id IS NULL
Parameters:
[
  "6o4l2tnpo1gkqap7rb7sepfvmn"
]
2 0.16 ms
"START TRANSACTION"
Parameters:
[]
3 0.27 ms
INSERT INTO carts (session_id, created_at, updated_at, expires_at, user_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "6o4l2tnpo1gkqap7rb7sepfvmn"
  "2026-02-05 11:11:15"
  "2026-02-05 11:11:15"
  "2026-03-07 11:11:15"
  null
]
4 2.01 ms
"COMMIT"
Parameters:
[]
5 0.66 ms
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = ? AND c0_.user_id IS NULL
Parameters:
[
  "6o4l2tnpo1gkqap7rb7sepfvmn"
]
6 0.36 ms
SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = ? ORDER BY c0_.created_at ASC
Parameters:
[
  1251
]
7 0.72 ms
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = ? AND c0_.user_id IS NULL
Parameters:
[
  "6o4l2tnpo1gkqap7rb7sepfvmn"
]
8 0.33 ms
SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = ? AND c0_.unit_price <> p1_.price
Parameters:
[
  1251
]

Database Connections

Name Service
default doctrine.dbal.default_connection
pim doctrine.dbal.pim_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\Cart 1

Entities Mapping

Class Mapping errors
App\Entity\Cart No errors.
App\Entity\User
  • The field App\Entity\User#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#user does not contain the required 'inversedBy="orders"' attribute.
App\Entity\CartItem No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Universe No errors.