GET https://dev.thevet.group/items/search/equine%20america/3

Response
200 OK
IP
216.73.217.129
Profiled on
Token
3f8215

Query Metrics

18 Database Queries
13 Different statements
50.15 ms Query time
0 Invalid entities
136 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.56 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
2 7.20 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.15 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 13.44 ms 
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
  "equine america"
  "active"
  1
  "Delivery Charges - Others"
  "Saracen Delivery Charges"
  "Documentation Charges"
  "Service Charges"
  "Shipping Cost"
  "Training Support"
  "goods"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.21 ms 
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: 
[
  "equine america"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.39 ms 
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: 
[
  "Equine America UK"
  1
  "Not Logged In"
  "Both"
  ""
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.31 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.79 ms 
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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9 3.39 ms 
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.tax_id AS tax_id_3, t0.name AS name_4, t0.description AS description_5, t0.manufacturer AS manufacturer_6, t0.sku AS sku_7, t0.rate AS rate_8, t0.stock AS stock_9, t0.tax_percentage AS tax_percentage_10, t0.status AS status_11, t0.is_discount AS is_discount_12, t0.modified AS modified_13, t0.created AS created_14, t0.slug AS slug_15, t0.is_controlled AS is_controlled_16, t0.cogs AS cogs_17, t0.short_expiry_discount AS short_expiry_discount_18, t0.short_expiry AS short_expiry_19, t0.target_gp AS target_gp_20, t0.is_otc AS is_otc_21, t0.related_items AS related_items_22, t0.display_name AS display_name_23, t0.otc_rate AS otc_rate_24, t0.is_clearance AS is_clearance_25, t0.total_ordered AS total_ordered_26, t0.product_type AS product_type_27, t0.shop_status AS shop_status_28, t0.discount AS discount_29, t0.base_rate AS base_rate_30, t0.intro AS intro_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.url AS url_34, t0.special_type_id AS special_type_id_35, t0.discount_type_id AS discount_type_id_36, t0.brand_id AS brand_id_37 FROM items t0 WHERE t0.item_id = ? LIMIT 1
Parameters: 
[
  "1625918000027744288"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 1.13 ms 
SELECT t0.id AS id_1, t0.price_list_id AS price_list_id_2, t0.name AS name_3, t0.status AS status_4, t0.modified AS modified_5, t0.created AS created_6 FROM price_lists t0 WHERE t0.price_list_id = ? LIMIT 1
Parameters: 
[
  "1625918000044039275"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 1.43 ms 
SELECT t0.id AS id_1, t0.price_list_item_id AS price_list_item_id_2, t0.item_id AS item_id_3, t0.name AS name_4, t0.rate AS rate_5, t0.modified AS modified_6, t0.created AS created_7, t0.price_list_id AS price_list_id_8 FROM price_list_items t0 WHERE t0.price_list_id = ? AND t0.item_id = ? LIMIT 1
Parameters: 
[
  16
  "1625918000027744288"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 1.21 ms 
SELECT SUM(b0_.qty) AS sclr_0 FROM batches b0_ WHERE b0_.item_id = ? GROUP BY b0_.item_id
Parameters: 
[
  "1625918000027744288"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 3.84 ms 
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.tax_id AS tax_id_3, t0.name AS name_4, t0.description AS description_5, t0.manufacturer AS manufacturer_6, t0.sku AS sku_7, t0.rate AS rate_8, t0.stock AS stock_9, t0.tax_percentage AS tax_percentage_10, t0.status AS status_11, t0.is_discount AS is_discount_12, t0.modified AS modified_13, t0.created AS created_14, t0.slug AS slug_15, t0.is_controlled AS is_controlled_16, t0.cogs AS cogs_17, t0.short_expiry_discount AS short_expiry_discount_18, t0.short_expiry AS short_expiry_19, t0.target_gp AS target_gp_20, t0.is_otc AS is_otc_21, t0.related_items AS related_items_22, t0.display_name AS display_name_23, t0.otc_rate AS otc_rate_24, t0.is_clearance AS is_clearance_25, t0.total_ordered AS total_ordered_26, t0.product_type AS product_type_27, t0.shop_status AS shop_status_28, t0.discount AS discount_29, t0.base_rate AS base_rate_30, t0.intro AS intro_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.url AS url_34, t0.special_type_id AS special_type_id_35, t0.discount_type_id AS discount_type_id_36, t0.brand_id AS brand_id_37 FROM items t0 WHERE t0.item_id = ? LIMIT 1
Parameters: 
[
  "1625918000020086805"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.86 ms 
SELECT t0.id AS id_1, t0.price_list_id AS price_list_id_2, t0.name AS name_3, t0.status AS status_4, t0.modified AS modified_5, t0.created AS created_6 FROM price_lists t0 WHERE t0.price_list_id = ? LIMIT 1
Parameters: 
[
  "1625918000044039275"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.98 ms 
SELECT t0.id AS id_1, t0.price_list_item_id AS price_list_item_id_2, t0.item_id AS item_id_3, t0.name AS name_4, t0.rate AS rate_5, t0.modified AS modified_6, t0.created AS created_7, t0.price_list_id AS price_list_id_8 FROM price_list_items t0 WHERE t0.price_list_id = ? AND t0.item_id = ? LIMIT 1
Parameters: 
[
  16
  "1625918000020086805"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.62 ms 
SELECT SUM(b0_.qty) AS sclr_0 FROM batches b0_ WHERE b0_.item_id = ? GROUP BY b0_.item_id
Parameters: 
[
  "1625918000020086805"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 3.10 ms 
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.tax_id AS tax_id_3, t0.name AS name_4, t0.description AS description_5, t0.manufacturer AS manufacturer_6, t0.sku AS sku_7, t0.rate AS rate_8, t0.stock AS stock_9, t0.tax_percentage AS tax_percentage_10, t0.status AS status_11, t0.is_discount AS is_discount_12, t0.modified AS modified_13, t0.created AS created_14, t0.slug AS slug_15, t0.is_controlled AS is_controlled_16, t0.cogs AS cogs_17, t0.short_expiry_discount AS short_expiry_discount_18, t0.short_expiry AS short_expiry_19, t0.target_gp AS target_gp_20, t0.is_otc AS is_otc_21, t0.related_items AS related_items_22, t0.display_name AS display_name_23, t0.otc_rate AS otc_rate_24, t0.is_clearance AS is_clearance_25, t0.total_ordered AS total_ordered_26, t0.product_type AS product_type_27, t0.shop_status AS shop_status_28, t0.discount AS discount_29, t0.base_rate AS base_rate_30, t0.intro AS intro_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.url AS url_34, t0.special_type_id AS special_type_id_35, t0.discount_type_id AS discount_type_id_36, t0.brand_id AS brand_id_37 FROM items t0 WHERE t0.item_id = ? LIMIT 1
Parameters: 
[
  "1625918000020055146"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 5.52 ms 
SELECT d.*, dt.type FROM 
                discounts d
                JOIN discount_types dt ON d.discount_type_id = dt.id
             WHERE (
                 JSON_CONTAINS(d.products, '["502"]') OR JSON_CONTAINS(d.products, '["all"]')
             OR 
                 JSON_CONTAINS(d.brands, '["5"]') OR JSON_CONTAINS(d.brands, '["all"]')
             )
            AND
                 (
                     JSON_CONTAINS(d.contacts, '["0"]') OR JSON_CONTAINS(d.contacts, '["all"]')
                 )
            AND
                 d.start_date <= '2026-06-26' 
           AND 
                 d.end_date >= '2026-06-26'
            AND
                 (d.discount_type_id = 1 OR d.discount_type_id = 3 OR d.discount_type_id = 4)
             AND d.status = 1
            LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\ItemImages 76
App\Entity\ApiDetails 26
App\Entity\Items 23
App\Entity\Carousel 2
App\Entity\Api 2
App\Entity\PriceListItems 2
App\Entity\Maintenance 1
App\Entity\User 1
App\Entity\Pages 1
App\Entity\Brands 1
App\Entity\PriceLists 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\BasketItems No errors.
App\Entity\Videos No errors.
App\Entity\Documents No errors.
App\Entity\Batches No errors.
App\Entity\ActivityLog No errors.
App\Entity\StockNotifications 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\PriceLists No errors.
App\Entity\PriceListItems No errors.
App\Entity\Contacts No errors.
App\Entity\Discounts No errors.