SHOW FULL COLUMNS FROM `jshop_base_addons` [ RunTime:0.006310s ]
SELECT * FROM `jshop_base_addons` WHERE `status` = 1 ORDER BY `utime` ASC [ RunTime:0.003979s ]
SHOW FULL COLUMNS FROM `jshop_b2c_products` [ RunTime:0.004545s ]
SHOW FULL COLUMNS FROM `jshop_b2c_goods` [ RunTime:0.006872s ]
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.252240s ]
SHOW FULL COLUMNS FROM `jshop_base_tags` [ RunTime:0.005890s ]
SHOW FULL COLUMNS FROM `jshop_base_resource` [ RunTime:0.003276s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '16d1bd4977bced2dfec304e9a864b105' LIMIT 1 [ RunTime:0.004826s ]
SHOW FULL COLUMNS FROM `jshop_base_tags_rel` [ RunTime:0.002471s ]
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.006335s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '8e6e308d4ff6ddafa024a9436024536e' LIMIT 1 [ RunTime:0.000651s ]
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.000972s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '7382d519c9c71a63237a3de4ac3b43ea' 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` = '27' AND `t`.`type` = 'goods' [ RunTime:0.000727s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0b90bda94ba14cbbe547256ae16d22b0' LIMIT 1 [ RunTime:0.000603s ]
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.000674s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '3ccba17df7801fb799b6eaa5e62c7308' LIMIT 1 [ RunTime:0.000556s ]
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.000533s ]
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.000726s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'dfb1bef3815ddf9cdbc21879e9b962de' LIMIT 1 [ RunTime:0.000596s ]
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.000663s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '4bb9cb3f64c96d52e95a6d0949836bbd' LIMIT 1 [ RunTime:0.000558s ]
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.000715s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '26e566c1976c7cb088c95f55d6f553c7' LIMIT 1 [ RunTime:0.000543s ]
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.000672s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1957cdbacd4e645e7e8f3dade015fef3' LIMIT 1 [ RunTime:0.000929s ]
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.000679s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '1ea14befb7ad955c40559290749cb63a' LIMIT 1 [ RunTime:0.001262s ]
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.000675s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'ca64cdade0326ae8e672c51a1a61c68c' 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` = '18' AND `t`.`type` = 'goods' [ RunTime:0.000675s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '2f8e76790a433d96596cb5b88bf0672c' LIMIT 1 [ RunTime:0.000588s ]
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.000702s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '5d8b9ada8b29c93f4ae760578b7c2221' LIMIT 1 [ RunTime:0.000548s ]
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.000654s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = 'a524f7fbe39f866a1519938300250026' LIMIT 1 [ RunTime:0.000560s ]
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.000682s ]
SELECT * FROM `jshop_base_resource` WHERE `id` = '0655344d72cfe96db51d1d51bfd2be36' LIMIT 1 [ RunTime:0.000551s ]
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.000665s ]