Symfony Profiler

Query Metrics

11 Database Queries

9 Different statements

9.29 ms Query time

1 Invalid entities

1 Managed entities

Queries

Group similar statements

pim connection

#▲	Time	Info
1	2.59 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 ORDER BY p.created_at DESC LIMIT ? Parameters: [`8`] 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 ORDER BY p.created_at DESC LIMIT ? 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 ORDER BY p.created_at DESC LIMIT 8;
2	0.71 ms	SELECT u., COUNT(p.id) as product_count FROM universe u LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true WHERE u.is_active = true GROUP BY u.id ORDER BY u.sort_order ASC, u.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT u., COUNT(p.id) as product_count FROM universe u LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true WHERE u.is_active = true GROUP BY u.id ORDER BY u.sort_order ASC, u.name ASC SELECT u.*, COUNT(p.id) as product_count FROM universe u LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true WHERE u.is_active = true GROUP BY u.id ORDER BY u.sort_order ASC, u.name ASC;
3	0.23 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;

#▲

Time

Info

2.59 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
    ORDER BY p.created_at DESC
    LIMIT ?

Parameters:

[
  8
]

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
ORDER BY
  p.created_at DESC
LIMIT
  ?

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
    ORDER BY p.created_at DESC
    LIMIT 8;

0.71 ms

SELECT u.*, COUNT(p.id) as product_count
    FROM universe u
    LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true
    WHERE u.is_active = true
    GROUP BY u.id
    ORDER BY u.sort_order ASC, u.name ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  u.*,
  COUNT(p.id) as product_count
FROM
  universe u
  LEFT JOIN product p ON p.universe_id = u.id
  AND p.is_active = true
WHERE
  u.is_active = true
GROUP BY
  u.id
ORDER BY
  u.sort_order ASC,
  u.name ASC

SELECT u.*, COUNT(p.id) as product_count
    FROM universe u
    LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true
    WHERE u.is_active = true
    GROUP BY u.id
    ORDER BY u.sort_order ASC, u.name ASC;

0.23 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/

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