Query Metrics
431
Database Queries
7
Different statements
54.20 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
13.79 ms (25.44%) |
157 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_entered AS date_entered_3, t0.slug AS slug_4, t0.sort AS sort_5 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
75
]
|
12.77 ms (23.56%) |
67 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.sort AS sort_4, t0.attribute_id AS attribute_id_5 FROM attribute_items t0 INNER JOIN attribute_items_products ON t0.id = attribute_items_products.attribute_items_id WHERE attribute_items_products.products_id = ?
Parameters:
[
29202
]
|
10.91 ms (20.12%) |
71 |
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 INNER JOIN products_category ON t0.id = products_category.category_id WHERE products_category.products_id = ?
Parameters:
[
29166
]
|
8.03 ms (14.81%) |
67 |
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:
[
21072
]
|
6.75 ms (12.44%) |
67 |
SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.name AS name_3, t0.value AS value_4, t0.sort AS sort_5, t0.product_id AS product_id_6 FROM product_info t0 WHERE t0.product_id = ?
Parameters:
[
29202
]
|
1.53 ms (2.82%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_entered AS date_entered_3, t0.date_modified AS date_modified_4, t0.description AS description_5, t0.code1c AS code1c_6, t0.barcode AS barcode_7, t0.status AS status_8, t0.price AS price_9, t0.price_income AS price_income_10, t0.mark_up AS mark_up_11, t0.min_mark_up AS min_mark_up_12, t0.packing_type AS packing_type_13, t0.packing_type_count AS packing_type_count_14, t0.discounts AS discounts_15, t0.count_order AS count_order_16, t0.product_to_order AS product_to_order_17, t0.article AS article_18, t0.nds AS nds_19, t0.service AS service_20, t0.transport_service AS transport_service_21, t0.exise AS exise_22, t0.expiration_date AS expiration_date_23, t0.unit_volume AS unit_volume_24, t0.net_weight AS net_weight_25, t0.gross_weight AS gross_weight_26, t0.go_by_weight AS go_by_weight_27, t0.packaging AS packaging_28, t0.old_code AS old_code_29, t0.show AS show_30, t0.balance AS balance_31, t0.deleted AS deleted_32, t0.category_cnt AS category_cnt_33, t0.price_category AS price_category_34, t0.is_salle AS is_salle_35, t0.is_new AS is_new_36, t0.is_top AS is_top_37, t0.old_price AS old_price_38, t0.discount_percent AS discount_percent_39, t0.video AS video_40, t0.is_video AS is_video_41, t0.is_free_shipping AS is_free_shipping_42, t0.warranty_period AS warranty_period_43, t0.min_balance AS min_balance_44, t0.min_balance_admin AS min_balance_admin_45, t0.main_category_id AS main_category_id_46, t0.modified_user_id AS modified_user_id_47, t0.created_by_id AS created_by_id_48, t0.measurement_unit_id AS measurement_unit_id_49, t0.site_product_id AS site_product_id_50, t0.storage_id AS storage_id_51, t0.storage_element_id AS storage_element_id_52, t0.language_id AS language_id_53, t0.translations_id AS translations_id_54, t0.main_media_id AS main_media_id_55, t0.main_media_hover_id AS main_media_hover_id_56 FROM products t0 WHERE t0.show = ?
Parameters:
[
1
]
|
0.44 ms (0.82%) |
1 |
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 ORDER BY t0.sort ASC
Parameters:
[] |
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.