Query Metrics
15
Database Queries
15
Different statements
47.43 ms
Query time
0
Invalid entities
41
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.08 ms (25.46%) |
1 |
SELECT i0_.id AS id_0, i0_.item_id AS item_id_1, i0_.tax_id AS tax_id_2, i0_.name AS name_3, i0_.description AS description_4, i0_.manufacturer AS manufacturer_5, i0_.sku AS sku_6, i0_.rate AS rate_7, i0_.stock AS stock_8, i0_.tax_percentage AS tax_percentage_9, i0_.status AS status_10, i0_.is_discount AS is_discount_11, i0_.modified AS modified_12, i0_.created AS created_13, i0_.slug AS slug_14, i0_.is_controlled AS is_controlled_15, i0_.cogs AS cogs_16, i0_.short_expiry_discount AS short_expiry_discount_17, i0_.short_expiry AS short_expiry_18, i0_.target_gp AS target_gp_19, i0_.is_otc AS is_otc_20, i0_.related_items AS related_items_21, i0_.display_name AS display_name_22, i0_.otc_rate AS otc_rate_23, i0_.is_clearance AS is_clearance_24, i0_.total_ordered AS total_ordered_25, i0_.product_type AS product_type_26, i0_.shop_status AS shop_status_27, i0_.discount AS discount_28, i0_.base_rate AS base_rate_29, i0_.intro AS intro_30, i0_.meta_title AS meta_title_31, i0_.meta_description AS meta_description_32, i0_.url AS url_33, i1_.id AS id_34, i1_.image AS image_35, i1_.is_default AS is_default_36, i1_.modified AS modified_37, i1_.created AS created_38, i1_.order_by AS order_by_39, i2_.id AS id_40, i3_.id AS id_41, i3_.name AS name_42, i3_.modified AS modified_43, i3_.created AS created_44, i0_.special_type_id AS special_type_id_45, i0_.discount_type_id AS discount_type_id_46, i0_.brand_id AS brand_id_47, i1_.item_id AS item_id_48, i2_.items_id AS items_id_49, i2_.item_categories_id AS item_categories_id_50 FROM items i0_ LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id WHERE i0_.is_otc = ? AND i0_.manufacturer = ? AND i0_.status = ? AND i0_.shop_status = ? AND i0_.name NOT IN (?, ?, ?, ?, ?, ?) AND i0_.product_type = ? ORDER BY i0_.display_name ASC
Parameters:
[ 1 "allflex" "active" 1 "Delivery Charges - Others" "Saracen Delivery Charges" "Documentation Charges" "Service Charges" "Shipping Cost" "Training Support" "goods" ]
|
||||||||||||||||||||||||||||||||
|
7.35 ms (15.51%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, display_name_22 FROM (SELECT i0_.id AS id_0, i0_.item_id AS item_id_1, i0_.tax_id AS tax_id_2, i0_.name AS name_3, i0_.description AS description_4, i0_.manufacturer AS manufacturer_5, i0_.sku AS sku_6, i0_.rate AS rate_7, i0_.stock AS stock_8, i0_.tax_percentage AS tax_percentage_9, i0_.status AS status_10, i0_.is_discount AS is_discount_11, i0_.modified AS modified_12, i0_.created AS created_13, i0_.slug AS slug_14, i0_.is_controlled AS is_controlled_15, i0_.cogs AS cogs_16, i0_.short_expiry_discount AS short_expiry_discount_17, i0_.short_expiry AS short_expiry_18, i0_.target_gp AS target_gp_19, i0_.is_otc AS is_otc_20, i0_.related_items AS related_items_21, i0_.display_name AS display_name_22, i0_.otc_rate AS otc_rate_23, i0_.is_clearance AS is_clearance_24, i0_.total_ordered AS total_ordered_25, i0_.product_type AS product_type_26, i0_.shop_status AS shop_status_27, i0_.discount AS discount_28, i0_.base_rate AS base_rate_29, i0_.intro AS intro_30, i0_.meta_title AS meta_title_31, i0_.meta_description AS meta_description_32, i0_.url AS url_33, i1_.id AS id_34, i1_.image AS image_35, i1_.is_default AS is_default_36, i1_.modified AS modified_37, i1_.created AS created_38, i1_.order_by AS order_by_39, i2_.id AS id_40, i3_.id AS id_41, i3_.name AS name_42, i3_.modified AS modified_43, i3_.created AS created_44 FROM items i0_ LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id WHERE i0_.is_otc = ? AND i0_.manufacturer = ? AND i0_.status = ? AND i0_.shop_status = ? AND i0_.name NOT IN (?, ?, ?, ?, ?, ?) AND i0_.product_type = ?) dctrn_result_inner ORDER BY display_name_22 ASC) dctrn_result LIMIT 8
Parameters:
[ 1 "allflex" "active" 1 "Delivery Charges - Others" "Saracen Delivery Charges" "Documentation Charges" "Service Charges" "Shipping Cost" "Training Support" "goods" ]
|
||||||||||||||||||||||||||||||||
|
4.33 ms (9.12%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.item_id AS item_id_1, i0_.tax_id AS tax_id_2, i0_.name AS name_3, i0_.description AS description_4, i0_.manufacturer AS manufacturer_5, i0_.sku AS sku_6, i0_.rate AS rate_7, i0_.stock AS stock_8, i0_.tax_percentage AS tax_percentage_9, i0_.status AS status_10, i0_.is_discount AS is_discount_11, i0_.modified AS modified_12, i0_.created AS created_13, i0_.slug AS slug_14, i0_.is_controlled AS is_controlled_15, i0_.cogs AS cogs_16, i0_.short_expiry_discount AS short_expiry_discount_17, i0_.short_expiry AS short_expiry_18, i0_.target_gp AS target_gp_19, i0_.is_otc AS is_otc_20, i0_.related_items AS related_items_21, i0_.display_name AS display_name_22, i0_.otc_rate AS otc_rate_23, i0_.is_clearance AS is_clearance_24, i0_.total_ordered AS total_ordered_25, i0_.product_type AS product_type_26, i0_.shop_status AS shop_status_27, i0_.discount AS discount_28, i0_.base_rate AS base_rate_29, i0_.intro AS intro_30, i0_.meta_title AS meta_title_31, i0_.meta_description AS meta_description_32, i0_.url AS url_33, i1_.id AS id_34, i1_.image AS image_35, i1_.is_default AS is_default_36, i1_.modified AS modified_37, i1_.created AS created_38, i1_.order_by AS order_by_39, i2_.id AS id_40, i3_.id AS id_41, i3_.name AS name_42, i3_.modified AS modified_43, i3_.created AS created_44 FROM items i0_ LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id WHERE i0_.is_otc = ? AND i0_.manufacturer = ? AND i0_.status = ? AND i0_.shop_status = ? AND i0_.name NOT IN (?, ?, ?, ?, ?, ?) AND i0_.product_type = ? ORDER BY i0_.display_name ASC) dctrn_result) dctrn_table
Parameters:
[ 1 "allflex" "active" 1 "Delivery Charges - Others" "Saracen Delivery Charges" "Documentation Charges" "Service Charges" "Shipping Cost" "Training Support" "goods" ]
|
||||||||||||||||||||||||||||||||
|
3.47 ms (7.31%) |
1 |
SELECT c0_.id AS id_0, c0_.job_title AS job_title_1, c0_.job_type AS job_type_2, c0_.posted AS posted_3, c0_.expires AS expires_4, c0_.url AS url_5, c0_.modified AS modified_6, c0_.created AS created_7 FROM careers c0_ WHERE c0_.posted <= ? AND c0_.expires >= ? ORDER BY c0_.job_title ASC
Parameters:
[ "2026-06-26" "2026-06-26" ]
|
||||||||||||||||||||||||||||||||
|
3.34 ms (7.05%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.website AS website_3, b0_.description AS description_4, b0_.order_by AS order_by_5, b0_.modified AS modified_6, b0_.created AS created_7, b0_.is_active AS is_active_8, b0_.api_name AS api_name_9, b0_.is_menu AS is_menu_10, b0_.has_otc AS has_otc_11, b0_.has_published AS has_published_12, b0_.banner_lg AS banner_lg_13, b0_.banner_sm AS banner_sm_14, b0_.featured_items AS featured_items_15, b0_.video AS video_16, b0_.meta_title_landing AS meta_title_landing_17, b0_.meta_description_landing AS meta_description_landing_18, b0_.meta_title_search AS meta_title_search_19, b0_.meta_description_search AS meta_description_search_20 FROM brands b0_ WHERE b0_.has_otc = ? ORDER BY b0_.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.95 ms (6.22%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.is_published = ? AND t0.is_header = ?
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||||||
|
2.45 ms (5.16%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.button AS button_3, t0.link AS link_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.modified AS modified_7, t0.created AS created_8 FROM pop_ups t0 WHERE t0.is_active = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.25 ms (4.74%) |
1 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.modified AS modified_3, t0.created AS created_4, t0.vat AS vat_5, t0.sub_total AS sub_total_6, t0.total AS total_7, t0.delivery_fee AS delivery_fee_8, t0.discount AS discount_9, t0.attatchment AS attatchment_10, t0.total_items AS total_items_11, t0.is_sales_order AS is_sales_order_12, t0.is_package AS is_package_13, t0.is_shipment AS is_shipment_14, t0.is_invoice AS is_invoice_15, t0.sales_order_no AS sales_order_no_16, t0.invoice_no AS invoice_no_17, t0.invoice_id AS invoice_id_18, t0.prescription AS prescription_19, t0.payment_link AS payment_link_20, t0.po_number AS po_number_21, t0.is_smart_order AS is_smart_order_22, t0.entity_id AS entity_id_23, t0.entity_user_id AS entity_user_id_24, t0.billing_address_id AS billing_address_id_25, t0.shipping_address_id AS shipping_address_id_26, t27.id AS id_28, t27.sales_order_id AS sales_order_id_29, t27.sales_order_number AS sales_order_number_30, t27.modified AS modified_31, t27.created AS created_32, t27.basket_id AS basket_id_33, t0.payment_type_id AS payment_type_id_34, t35.id AS id_36, t35.would_recommend AS would_recommend_37, t35.comments AS comments_38, t35.modified AS modified_39, t35.created AS created_40, t35.entity_user_id AS entity_user_id_41, t35.basket_id AS basket_id_42 FROM baskets t0 LEFT JOIN sales_orders t27 ON t27.basket_id = t0.id LEFT JOIN feedback t35 ON t35.basket_id = t0.id WHERE t0.entity_id = ? AND t0.status = ? LIMIT 1
Parameters:
[ 0 "open" ]
|
||||||||||||||||||||||||||||||||
|
1.72 ms (3.62%) |
1 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.modified AS modified_3, t0.created AS created_4, t0.default_message AS default_message_5, t0.custom_message AS custom_message_6, t0.use_default_message AS use_default_message_7, t0.user_id AS user_id_8 FROM maintenance t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
1.66 ms (3.49%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.website AS website_4, t0.description AS description_5, t0.order_by AS order_by_6, t0.modified AS modified_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.api_name AS api_name_10, t0.is_menu AS is_menu_11, t0.has_otc AS has_otc_12, t0.has_published AS has_published_13, t0.banner_lg AS banner_lg_14, t0.banner_sm AS banner_sm_15, t0.featured_items AS featured_items_16, t0.video AS video_17, t0.meta_title_landing AS meta_title_landing_18, t0.meta_description_landing AS meta_description_landing_19, t0.meta_title_search AS meta_title_search_20, t0.meta_description_search AS meta_description_search_21 FROM brands t0 WHERE t0.api_name = ? LIMIT 1
Parameters:
[
"allflex"
]
|
||||||||||||||||||||||||||||||||
|
1.64 ms (3.45%) |
1 |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.alt AS alt_2, c0_.caption_title AS caption_title_3, c0_.caption AS caption_4, c0_.url AS url_5, c0_.is_published AS is_published_6, c0_.modified AS modified_7, c0_.created AS created_8, c0_.order_by AS order_by_9, c0_.page AS page_10, c0_.brand AS brand_11, c0_.link AS link_12, c0_.display_rule AS display_rule_13, c0_.is_video AS is_video_14 FROM carousel c0_ WHERE c0_.brand = ? AND c0_.is_published = ? AND c0_.display_rule IN (?, ?, ?) ORDER BY c0_.order_by ASC
Parameters:
[ "Allflex" 1 "Not Logged In" "Both" "" ]
|
||||||||||||||||||||||||||||||||
|
1.57 ms (3.32%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.title = ? LIMIT 1
Parameters:
[
"Search Results"
]
|
||||||||||||||||||||||||||||||||
|
1.28 ms (2.71%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.modified AS modified_4, t0.created AS created_5, t0.api_id AS api_id_6 FROM api_details t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
"OTC ID"
]
|
||||||||||||||||||||||||||||||||
|
0.73 ms (1.53%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.is_published = ? AND t0.is_footer = ?
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||||||
|
0.63 ms (1.33%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.modified AS modified_4, t0.created AS created_5, t0.api_id AS api_id_6 FROM api_details t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ApiDetails | 26 |
| App\Entity\Brands | 6 |
| App\Entity\Pages | 4 |
| App\Entity\Api | 2 |
| App\Entity\Maintenance | 1 |
| App\Entity\User | 1 |
| App\Entity\PopUps | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Maintenance | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Baskets | No errors. |
| App\Entity\Entities | No errors. |
| App\Entity\EntityUsers | No errors. |
| App\Entity\Addresses | No errors. |
| App\Entity\SalesOrders | No errors. |
| App\Entity\PaymentTypes | No errors. |
| App\Entity\Feedback | No errors. |
| App\Entity\Pages | No errors. |
| App\Entity\Accordion | No errors. |
| App\Entity\Items | No errors. |
| App\Entity\ItemImages | No errors. |
| App\Entity\ItemsCategories | No errors. |
| App\Entity\ItemCategories | No errors. |
| App\Entity\SpecialTypes | No errors. |
| App\Entity\DiscountTypes | No errors. |
| App\Entity\Brands | No errors. |
| App\Entity\BrandIcons | No errors. |
| App\Entity\BrandsCategories | No errors. |
| App\Entity\Carousel | No errors. |
| App\Entity\ApiDetails | No errors. |
| App\Entity\Api | No errors. |
| App\Entity\Careers | No errors. |
| App\Entity\PopUps | No errors. |