16.90 ms (31.53%)
|
8 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = 32436;
|
5.72 ms (10.67%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 INNER JOIN product_to_category ON t0.id = product_to_category.category_id WHERE product_to_category.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 INNER JOIN product_to_category ON t0.id = product_to_category.category_id WHERE product_to_category.product_id = 32436;
|
4.25 ms (7.93%)
|
8 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.name AS name_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.name AS name_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = 32436;
|
4.13 ms (7.71%)
|
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sortstatus AS sortstatus_2, c0_.product_id AS product_id_3 FROM campaign c0_ WHERE c0_.product_id = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sortstatus AS sortstatus_2, c0_.product_id AS product_id_3 FROM campaign c0_ WHERE c0_.product_id = 32436;
|
3.93 ms (7.34%)
|
8 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = 4528;
|
2.77 ms (5.17%)
|
7 |
SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.name AS name_2 FROM variant v0_ INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id INNER JOIN product p2_ ON p2_.id = p3_.product_id WHERE p2_.id = ?
SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.name AS name_2 FROM variant v0_ INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id INNER JOIN product p2_ ON p2_.id = p3_.product_id WHERE p2_.id = 39445;
|
2.75 ms (5.13%)
|
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC;
|
2.40 ms (4.48%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.commision_fee AS commision_fee_3, t0.installment AS installment_4, t0.is_default AS is_default_5, t0.virtual_pos_id AS virtual_pos_id_6 FROM pos_plan t0 WHERE t0.virtual_pos_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.commision_fee AS commision_fee_3, t0.installment AS installment_4, t0.is_default AS is_default_5, t0.virtual_pos_id AS virtual_pos_id_6 FROM pos_plan t0 WHERE t0.virtual_pos_id = 15;
|
1.92 ms (3.59%)
|
1 |
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?
Parameters: [
"firstPageIsLogin"
]
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = 'firstPageIsLogin';
|
1.63 ms (3.05%)
|
3 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [
"showPaymentPlanPrice"
]
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = 'showPaymentPlanPrice' LIMIT 1;
|
1.03 ms (1.92%)
|
1 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1;
|
0.99 ms (1.85%)
|
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.parent_id = 32436;
|
0.97 ms (1.80%)
|
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.id = '32436';
|
0.58 ms (1.09%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = 1;
|
0.51 ms (0.96%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.secure_url AS secure_url_4, t0.store AS store_5, t0.mid AS mid_6, t0.posnet_id AS posnet_id_7, t0.username AS username_8, t0.password AS password_9, t0.is_secure AS is_secure_10, t0.secure_key AS secure_key_11 FROM virtual_pos t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.secure_url AS secure_url_4, t0.store AS store_5, t0.mid AS mid_6, t0.posnet_id AS posnet_id_7, t0.username AS username_8, t0.password AS password_9, t0.is_secure AS is_secure_10, t0.secure_key AS secure_key_11 FROM virtual_pos t0;
|
0.50 ms (0.94%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC;
|
0.47 ms (0.88%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC;
|
0.47 ms (0.87%)
|
1 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0;
|
0.40 ms (0.74%)
|
1 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = 32436;
|
0.36 ms (0.67%)
|
1 |
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5, c0_.product_unit_id AS product_unit_id_6 FROM cart c0_ WHERE c0_.session_id = ?
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5, c0_.product_unit_id AS product_unit_id_6 FROM cart c0_ WHERE c0_.session_id = NULL;
|
0.31 ms (0.58%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id;
|
0.31 ms (0.58%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0 WHERE t0.id = 1;
|
0.28 ms (0.52%)
|
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0;
|