Query Metrics
3
Database Queries
3
Different statements
1.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.81 ms (50.30%) |
1 |
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[ "sports-trouser-red-44-1" 1 ]
|
||||||||||||||||||||
|
0.45 ms (28.08%) |
1 |
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.trending_products_title AS trending_products_title_18, t0.trending_products_description AS trending_products_description_19, t0.combined_kit_title AS combined_kit_title_20, t0.combined_kit_description AS combined_kit_description_21, t0.how_works_title AS how_works_title_22, t0.how_works_description AS how_works_description_23, t0.contact_us_image AS contact_us_image_24, t0.contact_us_title AS contact_us_title_25, t0.contact_us_description AS contact_us_description_26, t0.contact_us_map AS contact_us_map_27, t0.google_analytics_id AS google_analytics_id_28, t0.google_tag_manager_code AS google_tag_manager_code_29, t0.google_site_verification_code AS google_site_verification_code_30, t0.zoho_token AS zoho_token_31, t0.zoho_token_created_at AS zoho_token_created_at_32, t0.safex_token AS safex_token_33, t0.safex_token_created_at AS safex_token_created_at_34, t0.blue_dart_token AS blue_dart_token_35, t0.blue_dart_token_created_at AS blue_dart_token_created_at_36, t0.invoice_cc AS invoice_cc_37, t0.meta_title AS meta_title_38, t0.meta_description AS meta_description_39, t0.meta_keywords AS meta_keywords_40 FROM setting t0 LIMIT 1
Parameters:
[] |
||||||||||||||||||||
|
0.35 ms (21.61%) |
1 |
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.active = ? AND t0.slug = ? LIMIT 1
Parameters:
[ 1 "sports-trouser-red-44-1" ] |
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\Item | No errors. |
| App\Entity\ItemCategory | No errors. |
| App\Entity\ItemGroup | No errors. |
| App\Entity\Grade | No errors. |
| App\Entity\Tax | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CompositeItem | No errors. |
| App\Entity\ItemStock | No errors. |
| App\Entity\ItemImage | No errors. |
| App\Entity\School | No errors. |
| App\Entity\ItemMandatory | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\KeyFeature | No errors. |
| App\Entity\HowWorks | No errors. |