SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001676s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001264s ]
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.000443s ]
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.002202s ]
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.000321s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001929s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480886 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001926s ]
SELECT * FROM `tp_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000385s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001082s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480886,') > 0 ) AND `status` = 1 [ RunTime:0.000606s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 40 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.335796s ]
SELECT * FROM `tp_soft` WHERE `id` IN (247756,90621,260499,323975,271880,135887,323180,193736,225163,167261,225722,177186,162577,165734,264077,256195) AND `status` = '1' AND `id` <> 480886 [ RunTime:0.004032s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '宝宝巴士%' AND `status` = '1' AND `id` NOT IN (480886,90621,135887,162577,165734,167261,177186,193736,225163,225722,247756,256195,260499,264077,271880,323180,323975) [ RunTime:0.049279s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.399788s ]
SELECT * FROM `tp_soft` WHERE `id` IN (248004,466363,245620,464253,139776) AND `id` NOT IN (480886,90621,135887,162577,165734,167261,177186,193736,225163,225722,247756,256195,260499,264077,271880,323180,323975,473814,108535,220893,464820,234875,473804,473822,118666,188983,175914,467146,480829,90271,134363,234801,136062,480170,90332,173732,224829,473812,128441,473819,175470,108630,473818,136563,137282,480866,108553,473805,118302,279097,136123,135594,434245,137758,136141,272992,480818,111570,156704,278334,480924,84417,136747,480862,467144,88839,480808,175931,234827,177210,273506,480899,275795,480865,435216,480861,111728,473829,134769,458821,234799,90270,136744,136750,136797,480806,134033,118383,136626,90229,473803,278598,272902,136749,224866,118815,321356,480900,272430,125763,480603,483004,128721,125545,136391,480831,460208,235990,135597,118656,136742,274662,136512,480859,103940,108736,473802,272363,460206,234803,473807,243734,118267,473836,480917,234845,475388,116295,480810,480916,135900,135912,277660,273505,280541,480851,243733,128408,125757,480943,480848,278335,480843,125412,118572,148874,206297,276889,134770,118420,118431,274783,480923,136538,125362,234854,138173,135435,473833,480791,134053,480807,320953,118231,480908,108579,128407,274665,282031,135421,473813,89958,118800,278340,276898,473824,465171,224845,94854,460205,234825,119877,256202,273383,108669,283878,477832,175060,480839,224838,125849,480805,149584,337954,480860,279610,224875,175852,234811,108731,480845,111715,274664,142406,457540,125885,480816,173790,108663,221212,128492,273224,217657,480840,234794,118740,118475,128406,277676,84170,118255,467152,177214,108743,480841,238488,134318,128405,175898,113389,118396,118801) [ RunTime:0.004744s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.375990s ]
SELECT * FROM `tp_soft` WHERE `id` IN (184380,139858,275984,477929,110233) AND `status` = '1' AND `id` NOT IN (480886,90621,135887,162577,165734,167261,177186,193736,225163,225722,247756,256195,260499,264077,271880,323180,323975,473814,108535,220893,464820,234875,473804,473822,118666,188983,175914,467146,480829,90271,134363,234801,136062,480170,90332,173732,224829,473812,128441,473819,175470,108630,473818,136563,137282,480866,108553,473805,118302,279097,136123,135594,434245,137758,136141,272992,480818,111570,156704,278334,480924,84417,136747,480862,467144,88839,480808,175931,234827,177210,273506,480899,275795,480865,435216,480861,111728,473829,134769,458821,234799,90270,136744,136750,136797,480806,134033,118383,136626,90229,473803,278598,272902,136749,224866,118815,321356,480900,272430,125763,480603,483004,128721,125545,136391,480831,460208,235990,135597,118656,136742,274662,136512,480859,103940,108736,473802,272363,460206,234803,473807,243734,118267,473836,480917,234845,475388,116295,480810,480916,135900,135912,277660,273505,280541,480851,243733,128408,125757,480943,480848,278335,480843,125412,118572,148874,206297,276889,134770,118420,118431,274783,480923,136538,125362,234854,138173,135435,473833,480791,134053,480807,320953,118231,480908,108579,128407,274665,282031,135421,473813,89958,118800,278340,276898,473824,465171,224845,94854,460205,234825,119877,256202,273383,108669,283878,477832,175060,480839,224838,125849,480805,149584,337954,480860,279610,224875,175852,234811,108731,480845,111715,274664,142406,457540,125885,480816,173790,108663,221212,128492,273224,217657,480840,234794,118740,118475,128406,277676,84170,118255,467152,177214,108743,480841,238488,134318,128405,175898,113389,118396,118801,139776,245620,248004,464253,466363) [ RunTime:0.005332s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000543s ]
共有 0条评论