Query Metrics
7
Database Queries
4
Different statements
3.77 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.41 ms (37.44%) |
3 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password_new AS password_new_6, t0.token AS token_7, t0.salt AS salt_8 FROM sf_guard_user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.00 ms (26.42%) |
1 |
SELECT l0_.id AS id_0, l0_.product_id AS product_id_1, l0_.user_id AS user_id_2, l0_.quant_before AS quant_before_3, l0_.quant_after AS quant_after_4, l0_.diff AS diff_5, l0_.cart_amount AS cart_amount_6, l0_.afsm_open AS afsm_open_7, l0_.dawanda AS dawanda_8, l0_.dawanda_open AS dawanda_open_9, l0_.hzg AS hzg_10, l0_.modify_reason_id AS modify_reason_id_11, l0_.comment AS comment_12, l0_.date_modified AS date_modified_13, l0_.product_id AS product_id_14, l0_.modify_reason_id AS modify_reason_id_15, l0_.user_id AS user_id_16 FROM lager_product_user l0_ WHERE l0_.product_id = ? ORDER BY l0_.date_modified DESC LIMIT 10
Parameters:
[
76722
]
|
0.78 ms (20.54%) |
1 |
SELECT t0.product_id AS product_id_1, t0.model AS model_2, t0.sku AS sku_3, t0.quantity AS quantity_4, t0.warn_stock AS warn_stock_5, t0.image AS image_6, t0.video AS video_7, t0.manufacturer_id AS manufacturer_id_8, t0.designer_id AS designer_id_9, t0.designer_provision AS designer_provision_10, t0.shipping AS shipping_11, t0.price AS price_12, t0.input_price AS input_price_13, t0.unit_id AS unit_id_14, t0.units_per_item AS units_per_item_15, t0.points AS points_16, t0.tax_class_id AS tax_class_id_17, t0.date_available AS date_available_18, t0.weight AS weight_19, t0.length AS length_20, t0.width AS width_21, t0.height AS height_22, t0.subtract AS subtract_23, t0.minimum AS minimum_24, t0.maximum AS maximum_25, t0.sort_order AS sort_order_26, t0.status AS status_27, t0.date_added AS date_added_28, t0.date_modified AS date_modified_29, t0.viewed AS viewed_30, t0.stamp_preset AS stamp_preset_31, t0.template_id AS template_id_32, t0.reorder AS reorder_33, t0.seller_article_nr AS seller_article_nr_34, t0.startpage_hide AS startpage_hide_35, t0.sw_id AS sw_id_36, t0.sw_custom_template AS sw_custom_template_37, t0.selected_yarns_id AS selected_yarns_id_38, t0.billbee_id AS billbee_id_39, t0.beton_id AS beton_id_40, t0.is_wc_main AS is_wc_main_41, t0.has_options AS has_options_42, t0.is_box_main_product AS is_box_main_product_43, t0.box_quantity AS box_quantity_44, t0.mix_and_match AS mix_and_match_45, t0.manufacturer_id AS manufacturer_id_46, t0.designer_id AS designer_id_47, t0.template_id AS template_id_48, t0.stock_status_id AS stock_status_id_49, t0.unit_id AS unit_id_50, t0.tax_class_id AS tax_class_id_51, t0.box_main_product AS box_main_product_52 FROM oc_product t0 WHERE t0.product_id = ?
Parameters:
[
"76722"
]
|
0.59 ms (15.61%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.display_app AS display_app_4, t0.reduce_location AS reduce_location_5, t0.no_button_plus AS no_button_plus_6, t0.no_button_minus AS no_button_minus_7, t0.update_init AS update_init_8, t0.to_produktion_transport AS to_produktion_transport_9, t0.sort AS sort_10 FROM lager_modify_reason t0 WHERE t0.id = ?
Parameters:
[
23
]
|
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.