Symfony Profiler

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


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
SELECT * FROM product_image WHERE product_id IN (?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY is_primary DESC, sort_order ASC
SELECT COUNT(*) FROM product p LEFT JOIN universe u ON p.universe_id = u.id WHERE p.is_active = true AND u.slug = ?
SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC
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
SELECT uc.*
    FROM universe_characteristic uc
    JOIN universe u ON uc.universe_id = u.id
    WHERE u.slug = ?
    ORDER BY uc.sort_order ASC
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
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
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
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
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
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
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
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
SELECT u.*
    FROM universe u
    WHERE u.slug = ?
SELECT u.*
    FROM universe u
    WHERE u.slug = ?
SELECT u.*
    FROM universe u
    WHERE u.slug = ?
SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC

#▲	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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 12 OFFSET 36;
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`] View formatted query View runnable query Explain query SELECT * FROM product_image WHERE product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY is_primary DESC, sort_order ASC SELECT * FROM product_image WHERE product_id IN (22,21,23,27,39,37,38,48,49,50,65,66) ORDER BY is_primary DESC, sort_order ASC;
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"`] View formatted query View runnable query Explain query SELECT COUNT() FROM product p LEFT JOIN universe u ON p.universe_id = u.id WHERE p.is_active = true AND u.slug = ? SELECT COUNT(*) FROM product p LEFT JOIN universe u ON p.universe_id = u.id WHERE p.is_active = true AND u.slug = '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: [] View formatted query View runnable query Explain query SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC;
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: [] View formatted query View runnable query Explain query 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 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;
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"`] View formatted query View runnable query Explain query SELECT uc.* FROM universe_characteristic uc JOIN universe u ON uc.universe_id = u.id WHERE u.slug = ? ORDER BY uc.sort_order ASC SELECT uc.* FROM universe_characteristic uc JOIN universe u ON uc.universe_id = u.id WHERE u.slug = 'fraises' ORDER BY uc.sort_order ASC;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
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"`] View formatted query View runnable query Explain query 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 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 = 'fraises' ORDER BY p.label ASC LIMIT 1000 OFFSET 0;
15	0.25 ms	SELECT u.* FROM universe u WHERE u.slug = ? Parameters: [`"fraises"`] View formatted query View runnable query Explain query SELECT u.* FROM universe u WHERE u.slug = ? SELECT u.* FROM universe u WHERE u.slug = 'fraises';
16	0.22 ms	SELECT u.* FROM universe u WHERE u.slug = ? Parameters: [`"fraises"`] View formatted query View runnable query Explain query SELECT u.* FROM universe u WHERE u.slug = ? SELECT u.* FROM universe u WHERE u.slug = 'fraises';
17	0.21 ms	SELECT u.* FROM universe u WHERE u.slug = ? Parameters: [`"fraises"`] View formatted query View runnable query Explain query SELECT u.* FROM universe u WHERE u.slug = ? SELECT u.* FROM universe u WHERE u.slug = '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: [] View formatted query View runnable query Explain query SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC;

default connection


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
"START TRANSACTION"
INSERT INTO carts (session_id, created_at, updated_at, expires_at, user_id) VALUES (?, ?, ?, ?, ?)
"COMMIT"
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
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
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
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

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.
App\Entity\Order	No errors.
App\Entity\Address	No errors.
App\Entity\ProductCharacteristic	No errors.
App\Entity\CategoryCharacteristic	No errors.
App\Entity\UniverseCharacteristic	No errors.

Symfony Profiler

GET https://dev.precision-tools.fr/produits?page=4&universe=fraises

Configuration Settings

Theme

Page Width

Query Metrics

Queries

pim connection

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping