SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.003332s ]
SELECT * FROM `jshop_base_addons` WHERE `status` = 1 ORDER BY `utime` ASC [ RunTime:0.002129s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.003306s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.003241s ]
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.038888s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.004270s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.002934s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '16d1bd4977bced2dfec304e9a864b105' LIMIT 1 [ RunTime:0.001341s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.002225s ]
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.001865s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '8e6e308d4ff6ddafa024a9436024536e' LIMIT 1 [ RunTime:0.009064s ]
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.002160s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '7382d519c9c71a63237a3de4ac3b43ea' LIMIT 1 [ RunTime:0.000657s ]
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.000928s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0b90bda94ba14cbbe547256ae16d22b0' LIMIT 1 [ RunTime:0.000600s ]
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.000908s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.000688s ]
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.000792s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '604fa15bf881f0345bbcceec811c3f4a' LIMIT 1 [ RunTime:0.009274s ]
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.004694s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'dfb1bef3815ddf9cdbc21879e9b962de' LIMIT 1 [ RunTime:0.000627s ]
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.000810s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '4bb9cb3f64c96d52e95a6d0949836bbd' LIMIT 1 [ RunTime:0.000582s ]
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.000762s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000568s ]
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.000746s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000610s ]
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.000741s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1ea14befb7ad955c40559290749cb63a' LIMIT 1 [ RunTime:0.000662s ]
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.000746s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'ca64cdade0326ae8e672c51a1a61c68c' LIMIT 1 [ RunTime:0.000654s ]
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.000765s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '2f8e76790a433d96596cb5b88bf0672c' LIMIT 1 [ RunTime:0.000762s ]
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.000730s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '5d8b9ada8b29c93f4ae760578b7c2221' 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` = '16' AND `t`.`type` = 'goods' [ RunTime:0.000752s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'a524f7fbe39f866a1519938300250026' LIMIT 1 [ RunTime:0.000571s ]
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.000730s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0655344d72cfe96db51d1d51bfd2be36' 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` = '14' AND `t`.`type` = 'goods' [ RunTime:0.001067s ]