Query Metrics
269
Database Queries
6
Different statements
27.67 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
18.06 ms (65.26%) |
192 |
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:
[
19954
]
|
|
3.50 ms (12.63%) |
37 |
SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.parent_id AS parent_id_15, t0.media_id AS media_id_16 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
9
]
|
|
3.43 ms (12.41%) |
37 |
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.id = ?
Parameters:
[
19954
]
|
|
1.45 ms (5.25%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.sort AS sort_1, c0_.name AS name_2 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN media_object m2_ ON c0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id WHERE c0_.main = ? AND c0_.status = ? AND c0_.type = ? ORDER BY c0_.sort ASC, c0_.name ASC LIMIT 30
Parameters:
[ "true" "active" "category" ] |
|
0.83 ms (3.01%) |
1 |
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, c1_.id AS id_14, c1_.date_entered AS date_entered_15, c1_.date_modified AS date_modified_16, c1_.created_by AS created_by_17, c1_.modified_user_id AS modified_user_id_18, c1_.name AS name_19, c1_.slug AS slug_20, c1_.status AS status_21, c1_.description AS description_22, c1_.main AS main_23, c1_.type AS type_24, c1_.product_cnt AS product_cnt_25, c1_.site_product_cnt AS site_product_cnt_26, c1_.sort AS sort_27, m2_.id AS id_28, m2_.upload_timestamp AS upload_timestamp_29, m2_.main AS main_30, m2_.file_path AS file_path_31, m2_.type AS type_32, m2_.name AS name_33, m2_.size AS size_34, m2_.sort AS sort_35, m3_.id AS id_36, m3_.upload_timestamp AS upload_timestamp_37, m3_.main AS main_38, m3_.file_path AS file_path_39, m3_.type AS type_40, m3_.name AS name_41, m3_.size AS size_42, m3_.sort AS sort_43, c0_.parent_id AS parent_id_44, c0_.media_id AS media_id_45, c1_.parent_id AS parent_id_46, c1_.media_id AS media_id_47, m2_.product_id AS product_id_48, m2_.orders_id AS orders_id_49, m2_.users_id AS users_id_50, m2_.account_worker_id AS account_worker_id_51, m2_.form_answer_id AS form_answer_id_52, m2_.job_id AS job_id_53, m2_.resize_img_parent_id AS resize_img_parent_id_54, m3_.product_id AS product_id_55, m3_.orders_id AS orders_id_56, m3_.users_id AS users_id_57, m3_.account_worker_id AS account_worker_id_58, m3_.form_answer_id AS form_answer_id_59, m3_.job_id AS job_id_60, m3_.resize_img_parent_id AS resize_img_parent_id_61 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN media_object m2_ ON c0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id WHERE c0_.main = ? AND c0_.status = ? AND c0_.type = ? AND c0_.id IN (?, ?, ?, ?, ?) ORDER BY c0_.sort ASC, c0_.name ASC
Parameters:
[ "true" "active" "category" 4 5 6 7 56 ] |
|
0.40 ms (1.44%) |
1 |
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN media_object m2_ ON c0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id WHERE c0_.main = ? AND c0_.status = ? AND c0_.type = ?
Parameters:
[ "true" "active" "category" ] |
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\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\SiteProducts | No errors. |
| App\Entity\MediaObject | No errors. |
| 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. |