SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.003198s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.005214s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.008141s ]
SELECT `g`.*,p.code as pcode,p.price as min_price FROM `jshop_b2c_goods` `g` LEFT JOIN `jshop_b2c_products` `p` ON `p`.`goods_id`=`g`.`id` ORDER BY `g`.`ctime` DESC [ RunTime:0.226255s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.004725s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.003226s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '16d1bd4977bced2dfec304e9a864b105' LIMIT 1 [ RunTime:0.005223s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.002564s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '29' AND `t`.`type` = 'goods' [ RunTime:0.006315s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '8e6e308d4ff6ddafa024a9436024536e' LIMIT 1 [ RunTime:0.000612s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '28' AND `t`.`type` = 'goods' [ RunTime:0.000964s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '7382d519c9c71a63237a3de4ac3b43ea' LIMIT 1 [ RunTime:0.000569s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '27' AND `t`.`type` = 'goods' [ RunTime:0.000737s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0b90bda94ba14cbbe547256ae16d22b0' LIMIT 1 [ RunTime:0.000628s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '26' AND `t`.`type` = 'goods' [ RunTime:0.000701s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.000564s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '25' AND `t`.`type` = 'goods' [ RunTime:0.000720s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.000557s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '24' AND `t`.`type` = 'goods' [ RunTime:0.000715s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'dfb1bef3815ddf9cdbc21879e9b962de' LIMIT 1 [ RunTime:0.000539s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '23' AND `t`.`type` = 'goods' [ RunTime:0.000678s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '4bb9cb3f64c96d52e95a6d0949836bbd' LIMIT 1 [ RunTime:0.000564s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '22' AND `t`.`type` = 'goods' [ RunTime:0.000681s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000755s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '21' AND `t`.`type` = 'goods' [ RunTime:0.000666s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000504s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '20' AND `t`.`type` = 'goods' [ RunTime:0.000666s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1ea14befb7ad955c40559290749cb63a' LIMIT 1 [ RunTime:0.000531s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '19' AND `t`.`type` = 'goods' [ RunTime:0.000680s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'ca64cdade0326ae8e672c51a1a61c68c' LIMIT 1 [ RunTime:0.000525s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '18' AND `t`.`type` = 'goods' [ RunTime:0.000660s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '2f8e76790a433d96596cb5b88bf0672c' LIMIT 1 [ RunTime:0.000528s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '17' AND `t`.`type` = 'goods' [ RunTime:0.000657s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '5d8b9ada8b29c93f4ae760578b7c2221' LIMIT 1 [ RunTime:0.000554s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '16' AND `t`.`type` = 'goods' [ RunTime:0.000666s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'a524f7fbe39f866a1519938300250026' LIMIT 1 [ RunTime:0.000504s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '15' AND `t`.`type` = 'goods' [ RunTime:0.000676s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0655344d72cfe96db51d1d51bfd2be36' LIMIT 1 [ RunTime:0.000531s ]
SELECT t.id as tags_id,`t`.`type`,`t`.`name`,`t`.`color`,`tr`.`rel_id` FROM `jshop_base_tags` `t` INNER JOIN `jshop_base_tags_rel` `tr` ON `tr`.`tags_id`=`t`.`id` WHERE `tr`.`rel_id` = '14' AND `t`.`type` = 'goods' [ RunTime:0.000900s ]