联系我们
微信扫一扫
添加您的专属客服
- 24h服务热线13057919266
- 服务热线13587779239
- 专注防爆工业照明12年
- 返回顶部
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-09-29 07:25:17 HTTP/1.1 GET : https://www.cxinyuan.com/index/article?id=5&type=album&c_id=2
- 运行时间 : 0.077242s [ 吞吐率：12.95req/s ] 内存消耗：5,245.90kb 文件加载：173
- 查询信息 : 80 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=e0df5c251628b548ba2021f4ef5ee868
- CONNECT:[ UseTime:0.000282s ] mysql:host=127.0.0.1;port=3306;dbname=cxinyuan_ssslll_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `card_config` [ RunTime:0.000628s ]
- SELECT * FROM `card_config` WHERE `key` = 'WebSite' AND `status` = 1 ORDER BY `sort` [ RunTime:0.000336s ]
- SELECT * FROM `card_config` WHERE `key` = 'company' AND `status` = 1 ORDER BY `sort` [ RunTime:0.000265s ]
- SHOW FULL COLUMNS FROM `card_column` [ RunTime:0.000536s ]
- SELECT COUNT(*) AS think_count FROM `card_column` `a` WHERE ( `a`.`column_type` IN ('1','2') ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000261s ]
- SELECT * FROM `card_column` `a` WHERE ( `a`.`column_type` IN ('1','2') ) AND `a`.`delete_time` IS NULL ORDER BY `sort`,`id` DESC LIMIT 0,9 [ RunTime:0.000308s ]
- SHOW FULL COLUMNS FROM `card_category` [ RunTime:0.000447s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` IN (1,2) ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000251s ]
- SHOW FULL COLUMNS FROM `card_attribute` [ RunTime:0.000432s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000184s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`video`,`thumbs`,`content`,`column_category`,`description` FROM `card_column` WHERE ( `pid` IN (1,2,9,13,20,21,22,23,24) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000358s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000205s ]
- SHOW FULL COLUMNS FROM `card_good` [ RunTime:0.000493s ]
- SELECT *,(SELECT COUNT(*) AS think_count FROM `card_good` `count_table` WHERE ( ( `count_table`.`column_id` =card_column.id ) ) AND `count_table`.`delete_time` IS NULL) AS `good_count`,`id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `pid` IN (3,4,5,6,7,10,11,12,25,26,44,27,28,29,30,31,14,32,15,33,16,17,34,35,36,37,38,39) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000424s ]
- SHOW FULL COLUMNS FROM `card_rel` [ RunTime:0.000433s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` IN (3,4,5,6,7,10,11,12,25,26,44,27,28,29,30,31,14,32,15,33,16,17,34,35,36,37,38,39) ORDER BY `id` [ RunTime:0.000277s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` IN (1,3,2) ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000260s ]
- SELECT `id`,`name`,`column_id` FROM `card_good` WHERE ( `column_id` IN (3,4,5,6,7,10,11,12,25,26,44,27,28,29,30,31,14,32,15,33,16,17,34,35,36,37,38,39) ) AND `card_good`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.001210s ]
- SHOW FULL COLUMNS FROM `card_good_rel` [ RunTime:0.000411s ]
- SELECT `id`,`good_id`,`c_id` FROM `card_good_rel` WHERE `type` = 'photo' AND `good_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,32,33,34,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,70,71,72,73,74,75,76,77,78,79,80,81,83,84,85,86) ORDER BY `id` [ RunTime:0.000581s ]
- SHOW FULL COLUMNS FROM `card_upload_detail` [ RunTime:0.000452s ]
- SELECT `id`,`type_id`,`photo_url` FROM `card_upload_detail` WHERE `id` IN (1,3,6,8,10,11,12,13,14,15,17,19,21,23,25,26,28,29,30,32,33,34,36,37,38,39,40,42,45,46,47,49,50,51,52,53,54,55,56,57,58,59,62,66,68,70,72,74,76,78,79,80,81,83,84,85,86,87,88,89,91,93,97,98,100,101,102,103,104,105,106,107,110,112,179,180,181,182,183,185) ORDER BY `id` [ RunTime:0.000628s ]
- SHOW FULL COLUMNS FROM `card_article` [ RunTime:0.000512s ]
- SELECT `id`,`name`,`avatar`,`title`,`describe`,`column_id`,`content`,`create_time` FROM `card_article` WHERE ( `column_id` IN (3,4,5,6,7,10,11,12,25,26,44,27,28,29,30,31,14,32,15,33,16,17,34,35,36,37,38,39) ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` LIMIT 1 [ RunTime:0.000332s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `id` IN (0,8) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000230s ]
- SELECT `id`,`name`,`avatar`,`title`,`content`,`describe`,`column_id`,`create_time` FROM `card_article` WHERE ( `column_id` IN (1,2,9,13,20,21,22,23,24) ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000343s ]
- SHOW FULL COLUMNS FROM `card_album` [ RunTime:0.000434s ]
- SELECT `id`,`name`,`avatar`,`title`,`column_id`,`create_time` FROM `card_album` WHERE `column_id` IN (1,2,9,13,20,21,22,23,24) ORDER BY `sort`,`id` [ RunTime:0.000245s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` IN (1,2,9,13,20,21,22,23,24) ORDER BY `id` [ RunTime:0.000235s ]
- SELECT `id`,`name`,`photo_url` FROM `card_upload_detail` WHERE `id` IN (150,153,152,154) ORDER BY `id` [ RunTime:0.000320s ]
- SELECT COUNT(*) AS think_count FROM `card_column` `a` WHERE ( `a`.`column_type` IN ('1','3') ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000220s ]
- SELECT * FROM `card_column` `a` WHERE ( `a`.`column_type` IN ('1','3') ) AND `a`.`delete_time` IS NULL ORDER BY `sort`,`id` DESC LIMIT 0,9 [ RunTime:0.000328s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` IN (1,2) ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000248s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000381s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`video`,`thumbs`,`content`,`column_category`,`description` FROM `card_column` WHERE ( `pid` IN (2,9,13,20) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000289s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000206s ]
- SELECT *,(SELECT COUNT(*) AS think_count FROM `card_good` `count_table` WHERE ( ( `count_table`.`column_id` =card_column.id ) ) AND `count_table`.`delete_time` IS NULL) AS `good_count`,`id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `pid` IN (3,4,5,6,7,10,11,12,44,14,15,16,17,37,38,39) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000383s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` IN (3,4,5,6,7,10,11,12,44,14,15,16,17,37,38,39) ORDER BY `id` [ RunTime:0.000256s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` IN (1,3,2) ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000229s ]
- SELECT `id`,`name`,`column_id` FROM `card_good` WHERE ( `column_id` IN (3,4,5,6,7,10,11,12,44,14,15,16,17,37,38,39) ) AND `card_good`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000895s ]
- SELECT `id`,`good_id`,`c_id` FROM `card_good_rel` WHERE `type` = 'photo' AND `good_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,32,33,34,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,70,71,72,73,74,75,76,77,78,79,80,81,83,84,85,86) ORDER BY `id` [ RunTime:0.000623s ]
- SELECT `id`,`type_id`,`photo_url` FROM `card_upload_detail` WHERE `id` IN (1,3,6,8,10,11,12,13,14,15,17,19,21,23,25,26,28,29,30,32,33,34,36,37,38,39,40,42,45,46,47,49,50,51,52,53,54,55,56,57,58,59,62,66,68,70,72,74,76,78,79,80,81,83,84,85,86,87,88,89,91,93,97,98,100,101,102,103,104,105,106,107,110,112,179,180,181,182,183,185) ORDER BY `id` [ RunTime:0.000676s ]
- SELECT `id`,`name`,`avatar`,`title`,`describe`,`column_id`,`content`,`create_time` FROM `card_article` WHERE ( `column_id` IN (3,4,5,6,7,10,11,12,44,14,15,16,17,37,38,39) ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` LIMIT 1 [ RunTime:0.000367s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `id` IN (0,8) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000230s ]
- SELECT `id`,`name`,`avatar`,`title`,`content`,`describe`,`column_id`,`create_time` FROM `card_article` WHERE ( `column_id` IN (2,9,13,20) ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000273s ]
- SELECT `id`,`name`,`avatar`,`title`,`column_id`,`create_time` FROM `card_album` WHERE `column_id` IN (2,9,13,20) ORDER BY `sort`,`id` [ RunTime:0.000268s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` IN (2,9,13,20) ORDER BY `id` [ RunTime:0.000234s ]
- SELECT `id`,`name`,`photo_url` FROM `card_upload_detail` WHERE `id` = 150 ORDER BY `id` [ RunTime:0.000187s ]
- SELECT COUNT(*) AS think_count FROM `card_column` `a` WHERE ( `a`.`id` = '2' ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000208s ]
- SELECT `a`.* FROM `card_column` `a` WHERE ( `a`.`id` = '2' ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`create_time` DESC,`a`.`id` DESC LIMIT 0,9 [ RunTime:0.000232s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` = 1 ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000218s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000236s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`video`,`thumbs`,`content`,`column_category`,`description` FROM `card_column` WHERE ( `pid` = 2 ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000256s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000187s ]
- SELECT *,(SELECT COUNT(*) AS think_count FROM `card_good` `count_table` WHERE ( ( `count_table`.`column_id` =card_column.id ) ) AND `count_table`.`delete_time` IS NULL) AS `good_count`,`id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `pid` IN (3,4,5,6,7) ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000357s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` IN (3,4,5,6,7) ORDER BY `id` [ RunTime:0.000224s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` IN (1,3) ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000235s ]
- SELECT `id`,`name`,`column_id` FROM `card_good` WHERE ( `column_id` IN (3,4,5,6,7) ) AND `card_good`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000531s ]
- SELECT `id`,`name`,`avatar`,`title`,`describe`,`column_id`,`content`,`create_time` FROM `card_article` WHERE ( `column_id` IN (3,4,5,6,7) ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` LIMIT 1 [ RunTime:0.000268s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `id` = 0 ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000214s ]
- SELECT `id`,`name`,`avatar`,`title`,`content`,`describe`,`column_id`,`create_time` FROM `card_article` WHERE ( `column_id` = 2 ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000224s ]
- SELECT `id`,`name`,`avatar`,`title`,`column_id`,`create_time` FROM `card_album` WHERE `column_id` = 2 ORDER BY `sort`,`id` [ RunTime:0.000230s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` = 2 ORDER BY `id` [ RunTime:0.000221s ]
- SELECT `id`,`name`,`photo_url` FROM `card_upload_detail` WHERE `id` = 150 ORDER BY `id` [ RunTime:0.000171s ]
- SELECT COUNT(*) AS think_count FROM `card_column` `a` WHERE ( `a`.`id` = '5' ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000205s ]
- SELECT `a`.* FROM `card_column` `a` WHERE ( `a`.`id` = '5' ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`create_time` DESC,`a`.`id` DESC LIMIT 0,9 [ RunTime:0.000246s ]
- SELECT `id`,`name`,`value` FROM `card_category` WHERE ( `key` = 'column' AND `id` = 3 ) AND `card_category`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000218s ]
- SELECT `id`,`name`,`value`,`pid` FROM `card_attribute` WHERE ( `id` = 0 ) AND `card_attribute`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000195s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`video`,`thumbs`,`content`,`column_category`,`description` FROM `card_column` WHERE ( `pid` = 5 ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000237s ]
- SELECT `id`,`title`,`name`,`pid`,`attribute_id`,`thumbs` FROM `card_column` WHERE ( `id` = 2 ) AND `card_column`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000216s ]
- SELECT `id`,`name`,`avatar`,`title`,`content`,`describe`,`column_id`,`create_time` FROM `card_article` WHERE ( `column_id` = 5 ) AND `card_article`.`delete_time` IS NULL ORDER BY `sort`,`id` [ RunTime:0.000231s ]
- SELECT `id`,`name`,`avatar`,`title`,`column_id`,`create_time` FROM `card_album` WHERE `column_id` = 5 ORDER BY `sort`,`id` [ RunTime:0.000191s ]
- SELECT `id`,`z_id`,`c_id`,`name` FROM `card_rel` WHERE `column` = 'album' AND `type` = 'photo' AND `z_id` = 3 ORDER BY `id` [ RunTime:0.000231s ]
- SELECT `id`,`type_id`,`photo_url` FROM `card_upload_detail` WHERE `id` IN (110,112,113) ORDER BY `id` [ RunTime:0.000217s ]
- SELECT `id`,`z_id`,`c_id`,`column`,`type` FROM `card_rel` WHERE `column` = 'column' AND `type` = 'photo' AND `z_id` = 5 ORDER BY `id` [ RunTime:0.000221s ]
- SELECT `id`,`pid`,`title` FROM `card_column` ORDER BY `sort`,`id` [ RunTime:0.000203s ]
- SELECT COUNT(*) AS think_count FROM `card_album` `a` WHERE `a`.`column_id` = '5' LIMIT 1 [ RunTime:0.000180s ]
- SELECT `a`.* FROM `card_album` `a` WHERE `a`.`column_id` = '5' ORDER BY `top` DESC,`hot` DESC,`sort`,`id` LIMIT 0,1000 [ RunTime:0.000227s ]
- SELECT `id`,`z_id`,`c_id`,`name` FROM `card_rel` WHERE `column` = 'album' AND `type` = 'photo' AND `z_id` = 3 ORDER BY `id` [ RunTime:0.000217s ]
- SELECT `id`,`type_id`,`photo_url` FROM `card_upload_detail` WHERE `id` IN (110,112,113) ORDER BY `id` [ RunTime:0.000216s ]
0.078006s
![{column['data'][0]['title']}](/storage/uploads/image/首页/xinyuan_bannerny-1.jpg)
