Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.24 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.72 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_category_id AS product_category_id_3 FROM product_category p0_ WHERE p0_.public = 1 ORDER BY p0_.id ASC LIMIT 6 Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_category_id AS product_category_id_3 FROM product_category p0_ WHERE p0_.public = 1 ORDER BY p0_.id ASC LIMIT 6 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_category_id AS product_category_id_3 FROM product_category p0_ WHERE p0_.public = 1 ORDER BY p0_.id ASC LIMIT 6;
2	0.52 ms	SELECT count(p0_.id) AS sclr_0 FROM product_category p0_ WHERE p0_.public = 1 Parameters: [] View formatted query View runnable query Explain query SELECT count(p0_.id) AS sclr_0 FROM product_category p0_ WHERE p0_.public = 1 SELECT count(p0_.id) AS sclr_0 FROM product_category p0_ WHERE p0_.public = 1;

#▲

Time

Info

0.72 ms

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_category_id AS product_category_id_3 FROM product_category p0_ WHERE p0_.public = 1 ORDER BY p0_.id ASC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.public AS public_2,
  p0_.product_category_id AS product_category_id_3
FROM
  product_category p0_
WHERE
  p0_.public = 1
ORDER BY
  p0_.id ASC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_category_id AS product_category_id_3 FROM product_category p0_ WHERE p0_.public = 1 ORDER BY p0_.id ASC LIMIT 6;

0.52 ms

SELECT count(p0_.id) AS sclr_0 FROM product_category p0_ WHERE p0_.public = 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(p0_.id) AS sclr_0
FROM
  product_category p0_
WHERE
  p0_.public = 1

SELECT count(p0_.id) AS sclr_0 FROM product_category p0_ WHERE p0_.public = 1;

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\ProductCategory	No errors.
App\Entity\ProductCategoryType	No errors.
App\Entity\Product	No errors.

Symfony Profiler

http://backend.soft99.ru/api/get/product/category?limit=6&sort=id

Configuration Settings

Theme