GET https://tkrentalstaging.thermokinginfo.com/products

Response
200 OK
IP
216.73.216.133
Profiled on
Token
32a0e2

Query Metrics

9 Database Queries
9 Different statements
5.24 ms Query time
0 Invalid entities
63 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.97 ms
(37.56%) 		1 
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id LEFT JOIN country c5_ ON c5_.id = p6_.country_id WHERE c5_.code IN (?) LIMIT 9
Parameters: 
[
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.09 ms
(20.87%) 		1 
SELECT p0_.id AS id_0, p0_.product_key AS product_key_1, p0_.name AS name_2, p0_.description AS description_3, p0_.image AS image_4, p0_.pharma_certified AS pharma_certified_5, p0_.product_detail AS product_detail_6, p0_.slug AS slug_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.id AS id_10, p1_.name AS name_11, p1_.slug AS slug_12, p2_.id AS id_13, p2_.name AS name_14, p2_.slug AS slug_15, t3_.id AS id_16, t3_.name AS name_17, t3_.slug AS slug_18, p4_.id AS id_19, p4_.name AS name_20, p4_.slug AS slug_21, c5_.id AS id_22, c5_.code AS code_23, c5_.name AS name_24, p0_.product_type_id AS product_type_id_25, p0_.product_subtype_id AS product_subtype_id_26, p0_.temp_control_id AS temp_control_id_27, p0_.power_source_id AS power_source_id_28, p2_.product_type_id AS product_type_id_29 FROM product p0_ LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id LEFT JOIN country c5_ ON c5_.id = p6_.country_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC
Parameters: 
[
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(14.84%) 		1 
SELECT DISTINCT p0_.product_detail AS product_detail_0 FROM product p0_ WHERE p0_.product_detail IS NOT NULL AND p0_.product_detail <> '' ORDER BY p0_.product_detail ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(8.56%) 		1 
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id LEFT JOIN country c5_ ON c5_.id = p6_.country_id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(5.63%) 		1 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p1_.id AS id_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.product_type_id AS product_type_id_6 FROM product_type p0_ LEFT JOIN product_subtype p1_ ON p0_.id = p1_.product_type_id ORDER BY p0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(4.68%) 		1 
SELECT p0_.slug AS slug_0, p1_.slug AS slug_1, p2_.product_detail AS product_detail_2, t3_.slug AS slug_3, p4_.slug AS slug_4 FROM product p2_ LEFT JOIN product_type p0_ ON p2_.product_type_id = p0_.id LEFT JOIN product_subtype p1_ ON p2_.product_subtype_id = p1_.id LEFT JOIN temp_control t3_ ON p2_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p2_.power_source_id = p4_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(4.47%) 		1 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM country t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(1.95%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM temp_control t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(1.45%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM power_source t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Product 40
App\Entity\Country 9
App\Entity\ProductSubtype 7
App\Entity\ProductType 3
App\Entity\TempControl 2
App\Entity\PowerSource 2

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\ProductType No errors.
App\Entity\ProductSubtype No errors.
App\Entity\TempControl No errors.
App\Entity\PowerSource No errors.
App\Entity\Country No errors.
App\Entity\ProductParameter No errors.