| Queries | Time | Rows |
| Connecting to DB | 1.965ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE `categories`.`id` = '40401'
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.115ms | 1 |
| Connecting to DB | 0.006ms | 1 |
| ROLLBACK | 0.11ms | 0 |
SELECT `advertisements`.*
FROM (`advertisements`)
WHERE sold IS NULL
ORDER BY rand()
LIMIT 0, 1 | 1.031ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_module' | 0.11ms | 8 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'web' | 0.074ms | 0 |
SELECT `menus`.*
FROM (`menus`)
WHERE `alias` = 'mobile_main_menu'
ORDER BY `menus`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
SELECT `menu_items`.*
FROM (`menu_items`)
WHERE `menu_id` = 3
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `states`.*
FROM (`states`)
WHERE `shortcut` = 'cz'
ORDER BY `states`.`ordering` ASC
LIMIT 0, 1 | 0.103ms | 1 |
SELECT `exchange_rates`.*
FROM (`exchange_rates`)
WHERE `shortcut` = 'CZK'
ORDER BY `exchange_rates`.`id` ASC
LIMIT 0, 1 | 0.09ms | 1 |
SELECT `basket_items`.*
FROM (`basket_items`)
WHERE good_id > 0
AND `random_customer_id` = 147575174
AND `owner` = 'not_loged'
ORDER BY `basket_items`.`id` ASC | 1.446ms | 0 |
SELECT `settings`.`id` AS `id`, `settings`.`vat_zero_value`, `settings`.`vat_low_value`, `settings`.`vat_hight_value`, `settings`.`vat_third_value`
FROM (`settings`)
RIGHT JOIN `states` ON (`states`.`setting` = `settings`.`alias`)
WHERE states.id ="cz"
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.119ms | 1 |
SELECT `settings`.*
FROM (`settings`)
WHERE `alias` = 'main'
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.19ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_menu' | 0.148ms | 0 |
SELECT `menus`.*
FROM (`menus`)
WHERE `alias` = 'Horni-menu'
ORDER BY `menus`.`id` ASC
LIMIT 0, 1 | 0.113ms | 0 |
SELECT `menu_items`.*
FROM (`menu_items`)
WHERE `menu_id` = 0
ORDER BY `lft` ASC | 0.111ms | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `visible` = 1
ORDER BY `lft` ASC | 1.498ms | 928 |
| Select MAX(`updated`) as `updated` From `categories` | 0.111ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_routes' | 0.13ms | 0 |
SELECT `settings`.*
FROM (`settings`)
WHERE `alias` = 'main'
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.205ms | 1 |
SELECT `branches`.*
FROM (`branches`)
WHERE `main` = 1
ORDER BY `branches`.`id` ASC
LIMIT 0, 1 | 0.118ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft < 1273
AND rgt > 1280
ORDER BY `lft` ASC | 0.125ms | 2 |
SELECT `goods`.`id` AS `id`
FROM (`goods`)
INNER JOIN `categories_goods` ON (`categories_goods`.`category_id` = 40401 AND `goods`.`id` = `categories_goods`.`good_id`)
WHERE categories_goods.id IS NOT NULL
AND `goods`.`visible_retail` = 1
GROUP BY `goods`.`id`
ORDER BY `goods`.`id` ASC | 0.542ms | 34 |
| INSERT INTO `_sys_request_params` (`data`, `parameters`, `admin_id`, `key`) VALUES ('a:34:{i:1035701;s:7:\"1035701\";i:1035801;s:7:\"1035801\";i:1045301;s:7:\"1045301\";i:1045401;s:7:\"1045401\";i:1105501;s:7:\"1105501\";i:1105601;s:7:\"1105601\";i:1105701;s:7:\"1105701\";i:1105801;s:7:\"1105801\";i:1105901;s:7:\"1105901\";i:1106001;s:7:\"1106001\";i:1130101;s:7:\"1130101\";i:1130201;s:7:\"1130201\";i:1135301;s:7:\"1135301\";i:1135401;s:7:\"1135401\";i:1178101;s:7:\"1178101\";i:1178201;s:7:\"1178201\";i:3083501;s:7:\"3083501\";i:3083601;s:7:\"3083601\";i:3142301;s:7:\"3142301\";i:3142401;s:7:\"3142401\";i:3142501;s:7:\"3142501\";i:3142601;s:7:\"3142601\";i:3142701;s:7:\"3142701\";i:3142801;s:7:\"3142801\";i:3142901;s:7:\"3142901\";i:3143001;s:7:\"3143001\";i:3330801;s:7:\"3330801\";i:3330901;s:7:\"3330901\";i:3346201;s:7:\"3346201\";i:3346301;s:7:\"3346301\";i:3349001;s:7:\"3349001\";i:3349101;s:7:\"3349101\";i:3638401;s:7:\"3638401\";i:3638501;s:7:\"3638501\";}', '||', 0, '5ed0b06a45996191767435') | 1.052ms | 1 |
| Select `id` From `goods_price_settings` where `default_eshop` = 1 Limit 1 | 0.109ms | 1 |
SELECT `goods_price_settings`.*
FROM (`goods_price_settings`)
WHERE `goods_price_settings`.`id` = 2
ORDER BY `goods_price_settings`.`sort` ASC
LIMIT 0, 1 | 0.07ms | 1 |
SELECT `image`.`id` AS `image:id`, `image`.`document_state_id` AS `image:document_state_id`, `image`.`name` AS `image:name`, `image`.`good_id` AS `image:good_id`, `image`.`description` AS `image:description`, `image`.`position` AS `image:position`, `image`.`default` AS `image:default`, `image`.`watermark` AS `image:watermark`, `image`.`tmp_id` AS `image:tmp_id`, `image`.`ext` AS `image:ext`, `image`.`auto_date_create` AS `image:auto_date_create`, `image`.`auto_date_update` AS `image:auto_date_update`, `image`.`auto_admin_create_id` AS `image:auto_admin_create_id`, `image`.`auto_admin_update_id` AS `image:auto_admin_update_id`, `image`.`updated` AS `image:updated`, `goods`.*
FROM (`goods`)
LEFT JOIN `images` AS `image` ON (`image`.`id` = `goods`.`image_id`)
INNER JOIN `categories_goods` ON (`categories_goods`.`category_id` = 40401 AND `goods`.`id` = `categories_goods`.`good_id`)
WHERE `goods`.`visible_retail` = 1
AND ( `goods`.`union_id` = 0 OR `goods`.`visible_self` = 1 )
AND union_id = 0
ORDER BY (`goods`.`goods_code_contractor`*1) ASC, `goods`.`goods_code_contractor` ASC, `goods`.`name` ASC
LIMIT 0, 20 | 2.637ms | 17 |
SELECT COUNT(*) AS `total_rows` FROM (SELECT `image`.`id` AS `image:id`, `image`.`document_state_id` AS `image:document_state_id`, `image`.`name` AS `image:name`, `image`.`good_id` AS `image:good_id`, `image`.`description` AS `image:description`, `image`.`position` AS `image:position`, `image`.`default` AS `image:default`, `image`.`watermark` AS `image:watermark`, `image`.`tmp_id` AS `image:tmp_id`, `image`.`ext` AS `image:ext`, `image`.`auto_date_create` AS `image:auto_date_create`, `image`.`auto_date_update` AS `image:auto_date_update`, `image`.`auto_admin_create_id` AS `image:auto_admin_create_id`, `image`.`auto_admin_update_id` AS `image:auto_admin_update_id`, `image`.`updated` AS `image:updated`, `goods`.*
FROM (`goods`)
LEFT JOIN `images` AS `image` ON (`image`.`id` = `goods`.`image_id`)
INNER JOIN `categories_goods` ON (`categories_goods`.`category_id` = 40401 AND `goods`.`id` = `categories_goods`.`good_id`)
WHERE `goods`.`visible_retail` = 1
AND ( `goods`.`union_id` = 0 OR `goods`.`visible_self` = 1 )
AND union_id = 0
ORDER BY (`goods`.`goods_code_contractor`*1) ASC, `goods`.`goods_code_contractor` ASC, `goods`.`name` ASC) AS `counted_results` | 2.66ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'pagination' | 0.068ms | 0 |
SELECT `states`.*
FROM (`states`)
WHERE `states`.`id` = 'cz'
ORDER BY `states`.`ordering` ASC
LIMIT 0, 1 | 0.098ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.111ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3346201
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.381ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 3346201 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.955ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.084ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3346201
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.327ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3896001
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.37ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 1611.570000 between `from` and `to` and `only_logged` = 0 | 0.07ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 1611.570000 between `from` and `to` | 0.064ms | 0 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_price' | 0.066ms | 0 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'goods_detail' | 0.067ms | 0 |
SELECT `images`.*
FROM (`images`)
WHERE `good_id` = 3349001
ORDER BY `images`.`id` ASC | 0.069ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3349001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.373ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3349001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.313ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `good_id` = 3349001
ORDER BY `images`.`id` ASC | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 429.750000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 429.750000 between `from` and `to` | 0.066ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.077ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.335ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 3142301 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.097ms | 14 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1079
AND rgt >= 1080
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1081
AND rgt >= 1082
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1086
AND rgt >= 1087
ORDER BY `lft` ASC | 0.076ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1101
AND rgt >= 1102
ORDER BY `lft` ASC | 0.08ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1103
AND rgt >= 1104
ORDER BY `lft` ASC | 0.076ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1105
AND rgt >= 1106
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1177
AND rgt >= 1178
ORDER BY `lft` ASC | 0.08ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1180
AND rgt >= 1181
ORDER BY `lft` ASC | 0.08ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1203
AND rgt >= 1204
ORDER BY `lft` ASC | 0.083ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1271
AND rgt >= 1272
ORDER BY `lft` ASC | 0.094ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.083ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1281
AND rgt >= 1282
ORDER BY `lft` ASC | 0.086ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1292
AND rgt >= 1293
ORDER BY `lft` ASC | 0.094ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1299
AND rgt >= 1300
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.401ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036726
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.071ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.343ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 3142501 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.091ms | 15 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1079
AND rgt >= 1080
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1081
AND rgt >= 1082
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1083
AND rgt >= 1084
ORDER BY `lft` ASC | 0.077ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1086
AND rgt >= 1087
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1101
AND rgt >= 1102
ORDER BY `lft` ASC | 0.077ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1103
AND rgt >= 1104
ORDER BY `lft` ASC | 0.075ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1105
AND rgt >= 1106
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1177
AND rgt >= 1178
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1180
AND rgt >= 1181
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1203
AND rgt >= 1204
ORDER BY `lft` ASC | 0.082ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1271
AND rgt >= 1272
ORDER BY `lft` ASC | 0.076ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.086ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1281
AND rgt >= 1282
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1292
AND rgt >= 1293
ORDER BY `lft` ASC | 0.078ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1299
AND rgt >= 1300
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.348ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036727
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.344ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 3142701 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.097ms | 15 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1079
AND rgt >= 1080
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1081
AND rgt >= 1082
ORDER BY `lft` ASC | 0.077ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1083
AND rgt >= 1084
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1086
AND rgt >= 1087
ORDER BY `lft` ASC | 0.075ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1101
AND rgt >= 1102
ORDER BY `lft` ASC | 0.08ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1103
AND rgt >= 1104
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1105
AND rgt >= 1106
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1177
AND rgt >= 1178
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1180
AND rgt >= 1181
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1203
AND rgt >= 1204
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1271
AND rgt >= 1272
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1281
AND rgt >= 1282
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1292
AND rgt >= 1293
ORDER BY `lft` ASC | 0.077ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1299
AND rgt >= 1300
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.316ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036728
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` | 0.066ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.075ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.389ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 3142901 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.093ms | 15 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1079
AND rgt >= 1080
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1081
AND rgt >= 1082
ORDER BY `lft` ASC | 0.101ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1083
AND rgt >= 1084
ORDER BY `lft` ASC | 0.082ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1086
AND rgt >= 1087
ORDER BY `lft` ASC | 0.08ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1101
AND rgt >= 1102
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1103
AND rgt >= 1104
ORDER BY `lft` ASC | 0.077ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1105
AND rgt >= 1106
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1177
AND rgt >= 1178
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1180
AND rgt >= 1181
ORDER BY `lft` ASC | 0.078ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1203
AND rgt >= 1204
ORDER BY `lft` ASC | 0.08ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1271
AND rgt >= 1272
ORDER BY `lft` ASC | 0.078ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1281
AND rgt >= 1282
ORDER BY `lft` ASC | 0.081ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1292
AND rgt >= 1293
ORDER BY `lft` ASC | 0.077ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1299
AND rgt >= 1300
ORDER BY `lft` ASC | 0.079ms | 3 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.315ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036729
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.103ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 157.020000 between `from` and `to` and `only_logged` = 0 | 0.078ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 157.020000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3083501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.332ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3083501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.306ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4033849
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 152.890000 between `from` and `to` and `only_logged` = 0 | 0.103ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 152.890000 between `from` and `to` | 0.066ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.072ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1035701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.355ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 1035701 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.933ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.08ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1035701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.352ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3892901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.386ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 247.930000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 247.930000 between `from` and `to` | 0.069ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` and `only_logged` = 0 | 0.079ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` | 0.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1045301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.371ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1045301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.313ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3892001
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.072ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.089ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.071ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1105501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.397ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 1105501 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.088ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.079ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1105501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.359ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3950201
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.075ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 1074.380000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 1074.380000 between `from` and `to` | 0.066ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.077ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1105701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.368ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 1105701 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.114ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.081ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1105701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.436ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3895901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.099ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` and `only_logged` = 0 | 0.09ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` | 0.098ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.078ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1105901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.343ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 1105901 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.084ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.078ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1105901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.311ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3895801
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` and `only_logged` = 0 | 0.071ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.077ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1130101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.351ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1130101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.313ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3891701
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.071ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` and `only_logged` = 0 | 0.079ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` | 0.07ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.078ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1135301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.375ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 1135301 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.092ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1180
AND rgt >= 1181
ORDER BY `lft` ASC | 0.081ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1274
AND rgt >= 1275
ORDER BY `lft` ASC | 0.087ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 1292
AND rgt >= 1293
ORDER BY `lft` ASC | 0.076ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1135301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.363ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3944901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.074ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 2190.080000 between `from` and `to` and `only_logged` = 0 | 0.07ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 2190.080000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.082ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1178101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.121ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1178101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4034459
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.071ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 128.100000 between `from` and `to` and `only_logged` = 0 | 0.069ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 128.100000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.116ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3330801
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.119ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3330801
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4015101
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.071ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` and `only_logged` = 0 | 0.081ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` | 0.07ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 115.700000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 115.700000 between `from` and `to` | 0.065ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3638401
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.437ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3638401
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4014701
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.072ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` and `only_logged` = 0 | 0.07ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` | 0.067ms | 0 |
| INSERT INTO `_sys_request_params` (`data`, `parameters`, `admin_id`, `key`) VALUES ('a:2:{s:7:\"pending\";a:12:{s:6:\"select\";a:15:{i:0;s:26:\"`image`.`id` AS `image:id`\";i:1;s:56:\"`image`.`document_state_id` AS `image:document_state_id`\";i:2;s:30:\"`image`.`name` AS `image:name`\";i:3;s:36:\"`image`.`good_id` AS `image:good_id`\";i:4;s:44:\"`image`.`description` AS `image:description`\";i:5;s:38:\"`image`.`position` AS `image:position`\";i:6;s:36:\"`image`.`default` AS `image:default`\";i:7;s:40:\"`image`.`watermark` AS `image:watermark`\";i:8;s:34:\"`image`.`tmp_id` AS `image:tmp_id`\";i:9;s:28:\"`image`.`ext` AS `image:ext`\";i:10;s:54:\"`image`.`auto_date_create` AS `image:auto_date_create`\";i:11;s:54:\"`image`.`auto_date_update` AS `image:auto_date_update`\";i:12;s:62:\"`image`.`auto_admin_create_id` AS `image:auto_admin_create_id`\";i:13;s:62:\"`image`.`auto_admin_update_id` AS `image:auto_admin_update_id`\";i:14;s:36:\"`image`.`updated` AS `image:updated`\";}s:3:\"set\";a:0:{}s:4:\"from\";a:0:{}s:4:\"join\";a:2:{i:0;a:3:{s:6:\"tables\";a:1:{i:0;s:19:\"`images` AS `image`\";}s:10:\"conditions\";s:35:\"(`image`.`id` = `goods`.`image_id`)\";s:4:\"type\";s:5:\"LEFT \";}i:1;a:3:{s:6:\"tables\";a:1:{i:0;s:18:\"`categories_goods`\";}s:10:\"conditions\";s:90:\"(`categories_goods`.`category_id` = 40401 AND `goods`.`id` = `categories_goods`.`good_id`)\";s:4:\"type\";s:6:\"INNER \";}}s:5:\"where\";a:3:{i:0;s:28:\"`goods`.`visible_retail` = 1\";i:1;s:60:\"AND ( `goods`.`union_id` = 0 OR `goods`.`visible_self` = 1 )\";i:2;s:16:\"AND union_id = 0\";}s:7:\"orderby\";a:0:{}s:5:\"order\";a:0:{}s:7:\"groupby\";a:0:{}s:6:\"having\";a:0:{}s:8:\"distinct\";b:0;s:5:\"limit\";b:0;s:6:\"offset\";b:0;}s:11:\"total_count\";i:17;}', '||', 0, '5ed0b06aca9ba1253961511') | 1.645ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.133ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.079ms | 0 |
SELECT `images`.*
FROM (`images`)
WHERE `good_id` = 3349001
ORDER BY `images`.`id` ASC | 0.075ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.077ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.074ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.088ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.085ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.081ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.072ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.102ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.072ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.082ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` and `only_logged` = 0 | 0.081ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.082ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.072ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.103ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.072ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.141ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.071ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.093ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.074ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.088ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.075ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.071ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 115.700000 between `from` and `to` and `only_logged` = 0 | 0.075ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 115.700000 between `from` and `to` | 0.067ms | 0 |
SELECT `id`, `id`
FROM (`categories`)
WHERE lft <= 1273
AND rgt >= 1280
ORDER BY `lft` DESC | 1.329ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE `categories`.`id` = '80061'
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.077ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft < 1273
AND rgt > 1280
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.844ms | 2 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 80061
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.097ms | 18 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 80061
AND lft <=1273
AND rgt >=1280
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.404ms | 1 |
SELECT `params`.*
FROM (`params`)
WHERE `params`.`id` = 1
ORDER BY `params`.`id` ASC
LIMIT 0, 1 | 0.072ms | 1 |
SELECT `param_values`.*
FROM (`param_values`)
WHERE `param_id` = 1
AND `model` = 'category'
AND `model_id` = 80061
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 0.067ms | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 32501
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.112ms | 24 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 32501
AND lft <=1273
AND rgt >=1280
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.432ms | 1 |
SELECT `params`.*
FROM (`params`)
WHERE `params`.`id` = 1
ORDER BY `params`.`id` ASC
LIMIT 0, 1 | 0.075ms | 1 |
SELECT `param_values`.*
FROM (`param_values`)
WHERE `param_id` = 1
AND `model` = 'category'
AND `model_id` = 32501
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 0.065ms | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 40401
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.077ms | 3 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 40401
AND lft <=1273
AND rgt >=1280
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.268ms | 0 |
SELECT `params`.*
FROM (`params`)
WHERE `params`.`id` = 1
ORDER BY `params`.`id` ASC
LIMIT 0, 1 | 0.072ms | 1 |
SELECT `param_values`.*
FROM (`param_values`)
WHERE `param_id` = 1
AND `model` = 'category'
AND `model_id` = 40401
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 0.063ms | 0 |
SELECT `contents`.*
FROM (`contents`)
WHERE `category_ids` = '|40401|'
ORDER BY `date` DESC | 0.468ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.082ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3346201
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.117ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3346201
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.15ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3896001
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.071ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 1611.570000 between `from` and `to` and `only_logged` = 0 | 0.07ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 1611.570000 between `from` and `to` | 0.067ms | 0 |
SELECT `images`.*
FROM (`images`)
WHERE `good_id` = 3349001
ORDER BY `images`.`id` ASC | 0.071ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.067ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3349001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.12ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3349001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.122ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `good_id` = 3349001
ORDER BY `images`.`id` ASC | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 429.750000 between `from` and `to` and `only_logged` = 0 | 0.075ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 429.750000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036726
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` | 0.066ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.121ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036727
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.077ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.079ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.119ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.158ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036728
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` and `only_logged` = 0 | 0.07ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 148.760000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.081ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.071ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3142901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3142901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.117ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036729
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 157.020000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 157.020000 between `from` and `to` | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3083501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3083501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4033849
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.071ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 152.890000 between `from` and `to` and `only_logged` = 0 | 0.071ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 152.890000 between `from` and `to` | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.075ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1035701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1035701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3892901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.075ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 247.930000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 247.930000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` | 0.067ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1045301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1045301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.14ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3892001
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` and `only_logged` = 0 | 0.07ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 661.160000 between `from` and `to` | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1105501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1105501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3950201
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.075ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 1074.380000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 1074.380000 between `from` and `to` | 0.066ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1105701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1105701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3895901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.075ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.071ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1105901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1105901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3895801
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` and `only_logged` = 0 | 0.071ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 991.740000 between `from` and `to` | 0.067ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.076ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1130101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.121ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1130101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3891701
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.074ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` | 0.083ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.077ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1135301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1135301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3944901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.073ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 2190.080000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 2190.080000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.077ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 1178101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 1178101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4034459
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.075ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 128.100000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 128.100000 between `from` and `to` | 0.068ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` and `only_logged` = 0 | 0.075ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3330801
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3330801
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.117ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4015101
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.074ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` and `only_logged` = 0 | 0.072ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` | 0.065ms | 0 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 115.700000 between `from` and `to` and `only_logged` = 0 | 0.074ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 115.700000 between `from` and `to` | 0.065ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3638401
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3638401
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4014701
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.074ms | 1 |
| Select * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` and `only_logged` = 0 | 0.073ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 82.640000 between `from` and `to` | 0.065ms | 0 |
| Total: 402 | 60.503ms | 1459 |
