SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001159s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000921s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` IN (14,16,8,44) OR `parent_id` IN (14,16,8,44) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000408s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 4 OR `parent_id` = 4 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000320s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 1 OR `parent_id` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000331s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001002s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479373 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000668s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000849s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479373,') > 0 ) AND `status` = 1 [ RunTime:0.000381s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.272880s ]
SELECT * FROM `tp_soft` WHERE `id` IN (203754,464730,483613,249627,302482,182968,231778,306832,484706,303264,201520,196317,254872,195825,480041,176379) AND `status` = '1' AND `id` <> 479373 [ RunTime:0.002616s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '云企查a%' AND `status` = '1' AND `id` NOT IN (479373,176379,182968,195825,196317,201520,203754,231778,249627,254872,302482,303264,306832,464730,480041,483613,484706) [ RunTime:0.003378s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.316151s ]
SELECT * FROM `tp_soft` WHERE `id` IN (199693,259316,306463,223673,466434) AND `id` NOT IN (479373,176379,182968,195825,196317,201520,203754,231778,249627,254872,302482,303264,306832,464730,480041,483613,484706) [ RunTime:0.001512s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.220011s ]
SELECT * FROM `tp_soft` WHERE `id` IN (112319,90808,112398,181955,468702) AND `status` = '1' AND `id` NOT IN (479373,176379,182968,195825,196317,201520,203754,231778,249627,254872,302482,303264,306832,464730,480041,483613,484706,199693,223673,259316,306463,466434) [ RunTime:0.001717s ]
共有 0条评论