| 1 |
0.41 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"it@birlaopenminds.com"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.email = 'it@birlaopenminds.com' LIMIT 1;
|
| 2 |
1.08 ms |
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.trending = ? ORDER BY t0.created_at DESC LIMIT 5
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 = 1 AND t0.trending = 1 ORDER BY t0.created_at DESC LIMIT 5;
|
| 3 |
1.04 ms |
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.combo_product = ? ORDER BY t0.created_at DESC LIMIT 5
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 = 1 AND t0.combo_product = 1 ORDER BY t0.created_at DESC LIMIT 5;
|
| 4 |
0.36 ms |
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
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;
|
| 5 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.slug = '' LIMIT 1;
|
| 6 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = 1;
|
| 7 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = 1;
|
| 8 |
0.28 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5, t0.parent_id AS parent_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM cart t0 WHERE t0.created_by = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5, t0.parent_id AS parent_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM cart t0 WHERE t0.created_by = 2;
|
| 9 |
0.38 ms |
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.id = ?
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.id = 868;
|
| 10 |
0.29 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 868 ORDER BY t0.`position` ASC;
|
| 11 |
0.29 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 868;
|
| 12 |
0.32 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 1735 ORDER BY t0.`position` ASC;
|
| 13 |
0.24 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 1735;
|
| 14 |
0.32 ms |
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.id = ?
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.id = 1458;
|
| 15 |
0.30 ms |
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.id = ?
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.id = 1471;
|
| 16 |
0.23 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 1735;
|
| 17 |
0.26 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 1734 ORDER BY t0.`position` ASC;
|
| 18 |
0.24 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 1734;
|
| 19 |
0.31 ms |
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.id = ?
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.id = 1457;
|
| 20 |
0.32 ms |
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.id = ?
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.id = 1470;
|
| 21 |
0.24 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 1734;
|
| 22 |
0.24 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 1733 ORDER BY t0.`position` ASC;
|
| 23 |
0.22 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 1733;
|
| 24 |
0.31 ms |
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.id = ?
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.id = 1456;
|
| 25 |
0.30 ms |
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.id = ?
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.id = 1469;
|
| 26 |
0.22 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 1733;
|
| 27 |
0.23 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 1732 ORDER BY t0.`position` ASC;
|
| 28 |
0.22 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 1732;
|
| 29 |
0.26 ms |
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.id = ?
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.id = 1455;
|
| 30 |
0.28 ms |
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.id = ?
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.id = 1468;
|
| 31 |
0.21 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 1732;
|
| 32 |
0.23 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 1731 ORDER BY t0.`position` ASC;
|
| 33 |
0.19 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 1731;
|
| 34 |
0.27 ms |
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.id = ?
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.id = 1454;
|
| 35 |
0.29 ms |
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.id = ?
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.id = 1467;
|
| 36 |
0.21 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 1731;
|
| 37 |
0.23 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 661 ORDER BY t0.`position` ASC;
|
| 38 |
0.24 ms |
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.unit AS unit_5, t0.size_chart AS size_chart_6, t0.active AS active_7, t0.imported AS imported_8 FROM item_group t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.unit AS unit_5, t0.size_chart AS size_chart_6, t0.active AS active_7, t0.imported AS imported_8 FROM item_group t0 WHERE t0.id = 184;
|
| 39 |
0.45 ms |
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.group_id = ? ORDER BY t0.size ASC
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.group_id = 184 ORDER BY t0.size ASC;
|
| 40 |
0.25 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.`position` AS position_3, t0.item_id AS item_id_4 FROM item_image t0 WHERE t0.item_id = 614 ORDER BY t0.`position` ASC;
|
| 41 |
0.25 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.item_id AS item_id_3, t0.group_id AS group_id_4 FROM item_mandatory t0 WHERE t0.item_id = 661;
|
| 42 |
0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.description AS description_4, t0.setting_id AS setting_id_5 FROM how_works t0 WHERE t0.setting_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.description AS description_4, t0.setting_id AS setting_id_5 FROM how_works t0 WHERE t0.setting_id = 1;
|
| 43 |
0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.setting_id AS setting_id_5 FROM key_feature t0 WHERE t0.setting_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.setting_id AS setting_id_5 FROM key_feature t0 WHERE t0.setting_id = 1;
|
| 44 |
1.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.publish = ? AND t0.footer_nav = ? ORDER BY t0.`position` ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.publish = 1 AND t0.footer_nav = 1 ORDER BY t0.`position` ASC;
|
| 45 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM item_category t0 WHERE t0.active = 1;
|
| 46 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM grade t0 WHERE t0.active = 1;
|