SELECT * FROM `g_config_currency` WHERE `delete_time` IS NULL AND `status` = 1 [ RunTime:0.000453s ]
SELECT * FROM `g_cart_storage` WHERE `site_id` = 4 AND `cookie_id` = '3ad091806a5014c867720faddd803015' LIMIT 1 [ RunTime:0.000462s ]
SELECT * FROM `g_seo` WHERE `site_id` = 4 AND `game_id` = 46 AND `code` = 'pokemon-held-items-go' LIMIT 1 [ RunTime:0.000571s ]
SELECT * FROM `g_seo` WHERE `site_id` = 4 AND `code` = 'Index' LIMIT 1 [ RunTime:0.002319s ]
SELECT * FROM `g_game` WHERE `delete_time` IS NULL AND `code` = 'pokemon-go' LIMIT 1 [ RunTime:0.000546s ]
SELECT * FROM `g_game_goods_category` WHERE `status` = 1 AND `delete_time` IS NULL AND `category_code` = 'held-items' AND `game_id` = 46 LIMIT 1 [ RunTime:0.000658s ]
SELECT * FROM `g_game_goods_category` WHERE `status` = 1 AND `delete_time` IS NULL AND `category_code` = 'held-items' AND `game_id` = 46 LIMIT 1 [ RunTime:0.000931s ]
SELECT * FROM `g_game_goods_category` WHERE `delete_time` IS NULL AND `status` = 1 AND `game_id` = 46 ORDER BY `sort` DESC,`category_code` ASC [ RunTime:0.000426s ]
SELECT `main`.* FROM `g_goods_on` `main` WHERE EXISTS ( SELECT * FROM `g_goods_on_specs` `s` WHERE ( s.goods_on_id = main.id ) AND `s`.`price` <> '999' AND `s`.`status` = '1' AND ( s.delete_time is null ) ) AND `status` = 1 AND `site_id` = 4 AND `game_id` = 46 AND `category_id` = 7713 AND `delete_time` IS NULL ORDER BY `sort` DESC,`title` ASC LIMIT 0,20 [ RunTime:0.001298s ]
SELECT * FROM `g_goods_on_specs` WHERE `status` = 1 AND `delete_time` IS NULL AND `price` <> '999' AND `goods_on_id` IN (105680,105681,105682,105683,105684,105685,106127,108519) ORDER BY `sort` DESC,`price` ASC,`id` ASC [ RunTime:0.000695s ]
SELECT COUNT(*) AS think_count FROM `g_goods_on` `main` WHERE `status` = 1 AND `site_id` = 4 AND `game_id` = 46 AND `category_id` = 7713 AND `delete_time` IS NULL AND EXISTS ( SELECT * FROM `g_goods_on_specs` `s` WHERE ( s.goods_on_id = main.id ) AND `s`.`price` <> '999' AND `s`.`status` = '1' AND ( s.delete_time is null ) ) LIMIT 1 [ RunTime:0.001003s ]