SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.002980s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.003963s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.006268s ]
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.081982s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.003397s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.003900s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '16d1bd4977bced2dfec304e9a864b105' LIMIT 1 [ RunTime:0.004272s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.005091s ]
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.006840s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '8e6e308d4ff6ddafa024a9436024536e' LIMIT 1 [ RunTime:0.000904s ]
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.000891s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '7382d519c9c71a63237a3de4ac3b43ea' LIMIT 1 [ RunTime:0.000530s ]
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.000881s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0b90bda94ba14cbbe547256ae16d22b0' LIMIT 1 [ RunTime:0.000642s ]
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.000776s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.000645s ]
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.000970s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.000821s ]
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.000820s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'dfb1bef3815ddf9cdbc21879e9b962de' LIMIT 1 [ RunTime:0.000681s ]
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.000850s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '4bb9cb3f64c96d52e95a6d0949836bbd' LIMIT 1 [ RunTime:0.000644s ]
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.000789s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000644s ]
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.002009s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000673s ]
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.000887s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1ea14befb7ad955c40559290749cb63a' LIMIT 1 [ RunTime:0.000607s ]
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.000765s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'ca64cdade0326ae8e672c51a1a61c68c' LIMIT 1 [ RunTime:0.000682s ]
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.000790s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '2f8e76790a433d96596cb5b88bf0672c' LIMIT 1 [ RunTime:0.000621s ]
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.000847s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '5d8b9ada8b29c93f4ae760578b7c2221' LIMIT 1 [ RunTime:0.000609s ]
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.000852s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'a524f7fbe39f866a1519938300250026' LIMIT 1 [ RunTime:0.000634s ]
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.000868s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0655344d72cfe96db51d1d51bfd2be36' LIMIT 1 [ RunTime:0.000707s ]
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.000761s ]