| Queries | Time | Rows |
| Connecting to DB | 19.111ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE `categories`.`id` = '59101'
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 9.659ms | 1 |
| Connecting to DB | 0.007ms | 1 |
| ROLLBACK | 0.108ms | 0 |
SELECT `advertisements`.*
FROM (`advertisements`)
WHERE sold IS NULL
ORDER BY rand()
LIMIT 0, 1 | 0.973ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_module' | 0.114ms | 8 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'web' | 0.094ms | 0 |
SELECT `menus`.*
FROM (`menus`)
WHERE `alias` = 'mobile_main_menu'
ORDER BY `menus`.`id` ASC
LIMIT 0, 1 | 0.084ms | 1 |
SELECT `menu_items`.*
FROM (`menu_items`)
WHERE `menu_id` = 3
ORDER BY `lft` ASC | 0.089ms | 4 |
SELECT `states`.*
FROM (`states`)
WHERE `shortcut` = 'cz'
ORDER BY `states`.`ordering` ASC
LIMIT 0, 1 | 0.097ms | 1 |
SELECT `exchange_rates`.*
FROM (`exchange_rates`)
WHERE `shortcut` = 'CZK'
ORDER BY `exchange_rates`.`id` ASC
LIMIT 0, 1 | 0.749ms | 1 |
SELECT `basket_items`.*
FROM (`basket_items`)
WHERE good_id > 0
AND `random_customer_id` = 1379419385
AND `owner` = 'not_loged'
ORDER BY `basket_items`.`id` ASC | 7.172ms | 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.106ms | 1 |
SELECT `settings`.*
FROM (`settings`)
WHERE `alias` = 'main'
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.151ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_menu' | 0.13ms | 0 |
SELECT `menus`.*
FROM (`menus`)
WHERE `alias` = 'Horni-menu'
ORDER BY `menus`.`id` ASC
LIMIT 0, 1 | 0.089ms | 0 |
SELECT `menu_items`.*
FROM (`menu_items`)
WHERE `menu_id` = 0
ORDER BY `lft` ASC | 0.092ms | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `visible` = 1
ORDER BY `lft` ASC | 1.077ms | 928 |
| Select MAX(`updated`) as `updated` From `categories` | 0.087ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_routes' | 0.103ms | 0 |
SELECT `settings`.*
FROM (`settings`)
WHERE `alias` = 'main'
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.21ms | 1 |
SELECT `branches`.*
FROM (`branches`)
WHERE `main` = 1
ORDER BY `branches`.`id` ASC
LIMIT 0, 1 | 0.111ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft < 219
AND rgt > 220
ORDER BY `lft` ASC | 0.124ms | 4 |
SELECT `goods`.`id` AS `id`
FROM (`goods`)
INNER JOIN `categories_goods` ON (`categories_goods`.`category_id` = 59101 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 | 1.11ms | 66 |
| INSERT INTO `_sys_request_params` (`data`, `parameters`, `admin_id`, `key`) VALUES ('a:66:{i:2642701;s:7:\"2642701\";i:2642801;s:7:\"2642801\";i:2642901;s:7:\"2642901\";i:2643001;s:7:\"2643001\";i:2644101;s:7:\"2644101\";i:2644201;s:7:\"2644201\";i:2644301;s:7:\"2644301\";i:2644401;s:7:\"2644401\";i:2644701;s:7:\"2644701\";i:2644801;s:7:\"2644801\";i:2646301;s:7:\"2646301\";i:2646401;s:7:\"2646401\";i:2647101;s:7:\"2647101\";i:2647201;s:7:\"2647201\";i:2647301;s:7:\"2647301\";i:2647401;s:7:\"2647401\";i:2839501;s:7:\"2839501\";i:2839601;s:7:\"2839601\";i:2839701;s:7:\"2839701\";i:2839801;s:7:\"2839801\";i:2840101;s:7:\"2840101\";i:2840201;s:7:\"2840201\";i:2876501;s:7:\"2876501\";i:2876601;s:7:\"2876601\";i:2877101;s:7:\"2877101\";i:2877201;s:7:\"2877201\";i:2877301;s:7:\"2877301\";i:2877401;s:7:\"2877401\";i:2877701;s:7:\"2877701\";i:2877801;s:7:\"2877801\";i:3625001;s:7:\"3625001\";i:3625101;s:7:\"3625101\";i:3626001;s:7:\"3626001\";i:3626101;s:7:\"3626101\";i:3708478;s:7:\"3708478\";i:3708479;s:7:\"3708479\";i:3708506;s:7:\"3708506\";i:3708507;s:7:\"3708507\";i:3708508;s:7:\"3708508\";i:3708509;s:7:\"3708509\";i:3708510;s:7:\"3708510\";i:3708511;s:7:\"3708511\";i:3708512;s:7:\"3708512\";i:3708513;s:7:\"3708513\";i:3708520;s:7:\"3708520\";i:3708521;s:7:\"3708521\";i:3709354;s:7:\"3709354\";i:3709355;s:7:\"3709355\";i:3709360;s:7:\"3709360\";i:3709361;s:7:\"3709361\";i:3709362;s:7:\"3709362\";i:3709363;s:7:\"3709363\";i:3709996;s:7:\"3709996\";i:3709997;s:7:\"3709997\";i:3710024;s:7:\"3710024\";i:3710025;s:7:\"3710025\";i:3710050;s:7:\"3710050\";i:3710051;s:7:\"3710051\";i:3711568;s:7:\"3711568\";i:3711569;s:7:\"3711569\";i:3712198;s:7:\"3712198\";i:3712199;s:7:\"3712199\";i:3713276;s:7:\"3713276\";i:3713277;s:7:\"3713277\";i:3713398;s:7:\"3713398\";i:3713399;s:7:\"3713399\";}', '||', 0, '5ece37c51c83b61164977') | 3.649ms | 1 |
| Select `id` From `goods_price_settings` where `default_eshop` = 1 Limit 1 | 0.122ms | 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.094ms | 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` = 59101 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 | 19.069ms | 20 |
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` = 59101 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` | 4.95ms | 1 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'pagination' | 0.118ms | 0 |
SELECT `states`.*
FROM (`states`)
WHERE `states`.`id` = 'cz'
ORDER BY `states`.`ordering` ASC
LIMIT 0, 1 | 4.28ms | 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.145ms | 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.094ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2642701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.194ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2642701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.227ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036242
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.097ms | 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 78.510000 between `from` and `to` and `only_logged` = 0 | 0.097ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 78.510000 between `from` and `to` | 0.087ms | 0 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'presenter_price' | 0.13ms | 0 |
| Select `key`, `text` From `i18n` where `language` = 'cs_CZ' and `group` = 'goods_detail' | 0.093ms | 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 165.290000 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 165.290000 between `from` and `to` | 0.097ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2642901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.469ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2642901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.153ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036243
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.091ms | 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 161.160000 between `from` and `to` and `only_logged` = 0 | 0.909ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 161.160000 between `from` and `to` | 0.087ms | 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 | 8.036ms | 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.097ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2644101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.152ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2644101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.26ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036248
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.093ms | 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 80.990000 between `from` and `to` and `only_logged` = 0 | 0.091ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 80.990000 between `from` and `to` | 0.085ms | 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 | 4.285ms | 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.091ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2644301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.188ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2644301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.151ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036249
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.095ms | 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 161.160000 between `from` and `to` and `only_logged` = 0 | 0.091ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 161.160000 between `from` and `to` | 0.1ms | 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.095ms | 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.088ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3626001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.675ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3626001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.154ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4033745
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.093ms | 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 16.530000 between `from` and `to` and `only_logged` = 0 | 4.644ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 16.530000 between `from` and `to` | 0.089ms | 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 16.530000 between `from` and `to` and `only_logged` = 0 | 4.742ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 16.530000 between `from` and `to` | 0.089ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3625001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.154ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3625001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.593ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4033747
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.095ms | 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 18.180000 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 18.180000 between `from` and `to` | 0.086ms | 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 | 4.753ms | 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.09ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2840101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.73ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2840101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.153ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036396
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.093ms | 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 264.460000 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 264.460000 between `from` and `to` | 0.086ms | 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.092ms | 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.087ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708506
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.931ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708506
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.155ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037665
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.093ms | 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.98ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 152.890000 between `from` and `to` | 3.838ms | 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 | 4.575ms | 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.089ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708478
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.167ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708478
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.551ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037814
ORDER BY `images`.`id` 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 70.250000 between `from` and `to` and `only_logged` = 0 | 0.095ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 70.250000 between `from` and `to` | 0.086ms | 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 | 4.411ms | 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.094ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3712198
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.743ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3712198
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.153ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038537
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.28ms | 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 78.510000 between `from` and `to` and `only_logged` = 0 | 4.299ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 78.510000 between `from` and `to` | 0.116ms | 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 | 5.477ms | 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.095ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3711568
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.156ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3711568
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.526ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038391
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.095ms | 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 6.610000 between `from` and `to` and `only_logged` = 0 | 0.096ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 6.610000 between `from` and `to` | 0.09ms | 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 | 4.685ms | 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.095ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708508
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.934ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708508
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.172ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037663
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.1ms | 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 33.060000 between `from` and `to` and `only_logged` = 0 | 1.081ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 33.060000 between `from` and `to` | 4.11ms | 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 | 4.663ms | 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.095ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708510
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.17ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708510
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 4.636ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4039531
ORDER BY `images`.`id` 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 37.190000 between `from` and `to` and `only_logged` = 0 | 0.092ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 37.190000 between `from` and `to` | 0.088ms | 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 37.190000 between `from` and `to` and `only_logged` = 0 | 4.518ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 37.190000 between `from` and `to` | 0.093ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708512
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 5.101ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708512
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.194ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037846
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.101ms | 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 33.060000 between `from` and `to` and `only_logged` = 0 | 4.777ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 33.060000 between `from` and `to` | 0.091ms | 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 | 4.602ms | 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.092ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3709354
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.614ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3709354
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.333ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038995
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.084ms | 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 37.190000 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 37.190000 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.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.072ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3709360
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 6.808ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3709360
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.422ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037849
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 4.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 45.450000 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 45.450000 between `from` and `to` | 0.088ms | 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.107ms | 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.092ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3709362
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.477ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3709362
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.466ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037850
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.1ms | 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 45.450000 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 45.450000 between `from` and `to` | 0.086ms | 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.095ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708520
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.5ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708520
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.458ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038423
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.109ms | 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 90.910000 between `from` and `to` and `only_logged` = 0 | 0.097ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 90.910000 between `from` and `to` | 0.087ms | 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.098ms | 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.092ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2876501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.641ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 2876501 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.153ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 219
AND rgt >= 220
ORDER BY `lft` ASC | 0.116ms | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 271
AND rgt >= 272
ORDER BY `lft` ASC | 0.113ms | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 325
AND rgt >= 326
ORDER BY `lft` ASC | 0.111ms | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 956
AND rgt >= 957
ORDER BY `lft` ASC | 0.111ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2876501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.494ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3607901
ORDER BY `images`.`id` 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 37.190000 between `from` and `to` and `only_logged` = 0 | 0.095ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 37.190000 between `from` and `to` | 0.096ms | 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.098ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2877101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.485ms | 1 |
SELECT `categories`.*
FROM (`categories`)
JOIN `categories_goods` ON (`deepest` = 1 AND `categories_goods`.`good_id` = 2877101 AND `categories_goods`.`category_id` = `categories`.`id`)
WHERE `visible` = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.116ms | 2 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 219
AND rgt >= 220
ORDER BY `lft` ASC | 0.109ms | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft <= 956
AND rgt >= 957
ORDER BY `lft` ASC | 0.111ms | 4 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2877101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.499ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3608201
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.1ms | 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 41.320000 between `from` and `to` and `only_logged` = 0 | 0.094ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 41.320000 between `from` and `to` | 0.105ms | 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` = 59101 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:33;}', '||', 0, '5ece37c67165b989829877') | 5.12ms | 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.083ms | 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 165.290000 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 165.290000 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.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.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.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 * 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 * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 16.530000 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 16.530000 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.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.073ms | 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.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.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.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.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.08ms | 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.084ms | 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.073ms | 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 * From `payment_discounts` Where (`goods_price_setting_id` = 2 or goods_price_setting_id = 0) and (payment_id = NULL or payment_id = 0) and 37.190000 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 37.190000 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 * 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 * 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.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.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 * 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.098ms | 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.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.068ms | 0 |
SELECT `else_images`.*
FROM (`else_images`)
WHERE `id` = 14801
ORDER BY `else_images`.`id` ASC
LIMIT 0, 1 | 0.088ms | 1 |
SELECT `id`, `id`
FROM (`categories`)
WHERE lft <= 219
AND rgt >= 220
ORDER BY `lft` DESC | 6.54ms | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE `categories`.`id` = '16101'
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.098ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE lft < 219
AND rgt > 220
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.121ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 16101
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.112ms | 11 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 16101
AND lft <=219
AND rgt >=220
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.105ms | 1 |
SELECT `params`.*
FROM (`params`)
WHERE `params`.`id` = 1
ORDER BY `params`.`id` ASC
LIMIT 0, 1 | 0.077ms | 1 |
SELECT `param_values`.*
FROM (`param_values`)
WHERE `param_id` = 1
AND `model` = 'category'
AND `model_id` = 16101
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 7.723ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 16901
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.136ms | 5 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 16901
AND lft <=219
AND rgt >=220
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.121ms | 1 |
SELECT `params`.*
FROM (`params`)
WHERE `params`.`id` = 1
ORDER BY `params`.`id` ASC
LIMIT 0, 1 | 9.478ms | 1 |
SELECT `param_values`.*
FROM (`param_values`)
WHERE `param_id` = 1
AND `model` = 'category'
AND `model_id` = 16901
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 19.921ms | 1 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 2501
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.125ms | 4 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 2501
AND lft <=219
AND rgt >=220
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.087ms | 1 |
SELECT `params`.*
FROM (`params`)
WHERE `params`.`id` = 1
ORDER BY `params`.`id` ASC
LIMIT 0, 1 | 0.076ms | 1 |
SELECT `param_values`.*
FROM (`param_values`)
WHERE `param_id` = 1
AND `model` = 'category'
AND `model_id` = 2501
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 0.068ms | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 2601
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.112ms | 9 |
SELECT `categories`.*
FROM (`categories`)
WHERE parent_id = 2601
AND lft <=219
AND rgt >=220
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC
LIMIT 0, 1 | 0.078ms | 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` = 2601
ORDER BY `param_values`.`id` ASC
LIMIT 0, 1 | 0.067ms | 0 |
SELECT `categories`.*
FROM (`categories`)
WHERE `parent_id` = 59101
AND visible = 1
ORDER BY `categories`.`lft` ASC, `categories`.`position` ASC | 0.08ms | 0 |
SELECT `else_images`.*
FROM (`else_images`)
WHERE `else_images`.`id` = 14801
ORDER BY `else_images`.`id` ASC
LIMIT 0, 1 | 0.069ms | 1 |
SELECT `contents`.*
FROM (`contents`)
WHERE `category_ids` = '|59101|'
ORDER BY `date` DESC | 0.38ms | 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.101ms | 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.073ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2642701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.125ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2642701
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.159ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036242
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 8.018ms | 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 78.510000 between `from` and `to` and `only_logged` = 0 | 11.546ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 78.510000 between `from` and `to` | 0.127ms | 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 165.290000 between `from` and `to` and `only_logged` = 0 | 0.114ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 165.290000 between `from` and `to` | 0.091ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2642901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.163ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2642901
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.154ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036243
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 9.644ms | 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 161.160000 between `from` and `to` and `only_logged` = 0 | 1.585ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 161.160000 between `from` and `to` | 1.856ms | 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.071ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2644101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.117ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2644101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036248
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.079ms | 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 80.990000 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 80.990000 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 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` = 2644301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.122ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2644301
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036249
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 161.160000 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 161.160000 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.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3626001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.131ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3626001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.122ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4033745
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 16.530000 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 16.530000 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 16.530000 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 16.530000 between `from` and `to` | 0.067ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3625001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3625001
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.157ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4033747
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 18.180000 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 18.180000 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` = 2840101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2840101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4036396
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 264.460000 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 264.460000 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.09ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708506
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.125ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708506
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.135ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037665
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 152.890000 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 152.890000 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 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.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708478
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708478
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037814
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 70.250000 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 70.250000 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.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3712198
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.122ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3712198
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038537
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 78.510000 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 78.510000 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.067ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3711568
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.118ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3711568
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.123ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038391
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 6.610000 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 6.610000 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 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.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708508
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.127ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708508
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.126ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037663
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 33.060000 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 33.060000 between `from` and `to` | 0.087ms | 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.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708510
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.121ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708510
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.118ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4039531
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 37.190000 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 37.190000 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 37.190000 between `from` and `to` and `only_logged` = 0 | 2.724ms | 0 |
| Select * From `customer_discounts` Where `customer_id` = 0 and (payment_id = NULL or payment_id = 0) and 37.190000 between `from` and `to` | 0.073ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3708512
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708512
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037846
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 33.060000 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 33.060000 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.068ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3709354
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.127ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3709354
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.114ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038995
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 37.190000 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 37.190000 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 0.000000 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 0.000000 between `from` and `to` | 0.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3709360
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.119ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3709360
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.123ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037849
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 45.450000 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 45.450000 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.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.069ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 3709362
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.118ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3709362
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.115ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4037850
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 45.450000 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 45.450000 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.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` = 3708520
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.123ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 3708520
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 4038423
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 90.910000 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 90.910000 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.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2876501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.119ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2876501
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.116ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3607901
ORDER BY `images`.`id` ASC
LIMIT 0, 1 | 0.093ms | 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 37.190000 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 37.190000 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.07ms | 0 |
SELECT `goods`.*
FROM (`goods`)
WHERE `union_id` = 2877101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.123ms | 1 |
SELECT `goods`.*
FROM (`goods`)
WHERE `goods`.`id` = 2877101
ORDER BY `goods`.`id` ASC
LIMIT 0, 1 | 0.127ms | 1 |
SELECT `images`.*
FROM (`images`)
WHERE `images`.`id` = 3608201
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 41.320000 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 41.320000 between `from` and `to` | 0.069ms | 0 |
| Total: 385 | 338.352ms | 1253 |
