Query Metrics
6
Database Queries
4
Different statements
3.85 ms
Query time
4
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.98 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.sort AS sort_1, c0_.name AS name_2 FROM category c0_ LEFT JOIN media_object m1_ ON c0_.media_id = m1_.id LEFT JOIN media_object m2_ ON m1_.id = m2_.resize_img_parent_id LEFT JOIN languages l3_ ON c0_.language_id = l3_.id LEFT JOIN category c4_ ON c0_.translation_id = c4_.id LEFT JOIN category c5_ ON c0_.id = c5_.translation_id WHERE c0_.slug = ? ORDER BY c0_.sort ASC, c0_.name ASC LIMIT 30
Parameters:
[
"frezeri"
]
|
| 2 | 1.01 ms |
SELECT c0_.id AS id_0, c0_.date_entered AS date_entered_1, c0_.date_modified AS date_modified_2, c0_.created_by AS created_by_3, c0_.modified_user_id AS modified_user_id_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.status AS status_7, c0_.description AS description_8, c0_.main AS main_9, c0_.type AS type_10, c0_.product_cnt AS product_cnt_11, c0_.site_product_cnt AS site_product_cnt_12, c0_.sort AS sort_13, c0_.seo_title AS seo_title_14, c0_.seo_description AS seo_description_15, m1_.id AS id_16, m1_.upload_timestamp AS upload_timestamp_17, m1_.main AS main_18, m1_.file_path AS file_path_19, m1_.type AS type_20, m1_.name AS name_21, m1_.size AS size_22, m1_.sort AS sort_23, m2_.id AS id_24, m2_.upload_timestamp AS upload_timestamp_25, m2_.main AS main_26, m2_.file_path AS file_path_27, m2_.type AS type_28, m2_.name AS name_29, m2_.size AS size_30, m2_.sort AS sort_31, l3_.id AS id_32, l3_.name AS name_33, l3_.key AS key_34, c4_.id AS id_35, c4_.date_entered AS date_entered_36, c4_.date_modified AS date_modified_37, c4_.created_by AS created_by_38, c4_.modified_user_id AS modified_user_id_39, c4_.name AS name_40, c4_.slug AS slug_41, c4_.status AS status_42, c4_.description AS description_43, c4_.main AS main_44, c4_.type AS type_45, c4_.product_cnt AS product_cnt_46, c4_.site_product_cnt AS site_product_cnt_47, c4_.sort AS sort_48, c4_.seo_title AS seo_title_49, c4_.seo_description AS seo_description_50, c5_.id AS id_51, c5_.date_entered AS date_entered_52, c5_.date_modified AS date_modified_53, c5_.created_by AS created_by_54, c5_.modified_user_id AS modified_user_id_55, c5_.name AS name_56, c5_.slug AS slug_57, c5_.status AS status_58, c5_.description AS description_59, c5_.main AS main_60, c5_.type AS type_61, c5_.product_cnt AS product_cnt_62, c5_.site_product_cnt AS site_product_cnt_63, c5_.sort AS sort_64, c5_.seo_title AS seo_title_65, c5_.seo_description AS seo_description_66, c0_.parent_id AS parent_id_67, c0_.media_id AS media_id_68, c0_.language_id AS language_id_69, c0_.translation_id AS translation_id_70, m1_.product_id AS product_id_71, m1_.orders_id AS orders_id_72, m1_.users_id AS users_id_73, m1_.account_worker_id AS account_worker_id_74, m1_.form_answer_id AS form_answer_id_75, m1_.job_id AS job_id_76, m1_.resize_img_parent_id AS resize_img_parent_id_77, m2_.product_id AS product_id_78, m2_.orders_id AS orders_id_79, m2_.users_id AS users_id_80, m2_.account_worker_id AS account_worker_id_81, m2_.form_answer_id AS form_answer_id_82, m2_.job_id AS job_id_83, m2_.resize_img_parent_id AS resize_img_parent_id_84, c4_.parent_id AS parent_id_85, c4_.media_id AS media_id_86, c4_.language_id AS language_id_87, c4_.translation_id AS translation_id_88, c5_.parent_id AS parent_id_89, c5_.media_id AS media_id_90, c5_.language_id AS language_id_91, c5_.translation_id AS translation_id_92 FROM category c0_ LEFT JOIN media_object m1_ ON c0_.media_id = m1_.id LEFT JOIN media_object m2_ ON m1_.id = m2_.resize_img_parent_id LEFT JOIN languages l3_ ON c0_.language_id = l3_.id LEFT JOIN category c4_ ON c0_.translation_id = c4_.id LEFT JOIN category c5_ ON c0_.id = c5_.translation_id WHERE c0_.slug = ? AND c0_.id IN (?) ORDER BY c0_.sort ASC, c0_.name ASC
Parameters:
[ "frezeri" 18 ] |
| 3 | 0.18 ms |
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
316
]
|
| 4 | 0.15 ms |
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
317
]
|
| 5 | 0.11 ms |
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
318
]
|
| 6 | 0.42 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN media_object m1_ ON c0_.media_id = m1_.id LEFT JOIN media_object m2_ ON m1_.id = m2_.resize_img_parent_id LEFT JOIN languages l3_ ON c0_.language_id = l3_.id LEFT JOIN category c4_ ON c0_.translation_id = c4_.id LEFT JOIN category c5_ ON c0_.id = c5_.translation_id WHERE c0_.slug = ?
Parameters:
[
"frezeri"
]
|
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\MediaObject | 4 |
| App\Entity\Category | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Products | No errors. |
| App\Entity\Attributes | No errors. |
| App\Entity\Faq |
|
| App\Entity\News | No errors. |
| App\Entity\Pages | No errors. |
| App\Entity\Projects | No errors. |
| App\Entity\SiteProducts | No errors. |
| App\Entity\Objects | No errors. |
| App\Entity\MediaObject | No errors. |
| App\Entity\Languages |
|
| App\Entity\Orders | No errors. |
| App\Entity\User |
|
| App\Entity\AccountWorker | No errors. |
| App\Entity\FormAnswer | No errors. |
| App\Entity\Jobs | No errors. |
| App\Entity\AttributeItems | No errors. |
| App\Entity\Coupons | No errors. |
| App\Entity\UsersDocs | No errors. |
| App\Entity\Workers | No errors. |
| App\Entity\AccountJobsList | No errors. |
| App\Entity\SiteProductsMedia | No errors. |
| App\Entity\Slide | No errors. |
| App\Entity\GalleryItems | No errors. |
| App\Entity\MenuItems | No errors. |
| App\Entity\VacancyRequest |
|
| App\Entity\MaterialMedia | No errors. |
| App\Entity\Accounts | No errors. |
| App\Entity\Posts | No errors. |
| App\Entity\Documents | No errors. |