SELECT * FROM `xcy_category` WHERE `status` = '1' AND `lang` = 'cn' AND `pid` = 0 ORDER BY `sort` ASC,`addtime` ASC,`id` ASC LIMIT 6 [ RunTime:0.000298s ]
SELECT * FROM `xcy_category` WHERE `pid` = 1 AND `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC,`id` ASC [ RunTime:0.000271s ]
SELECT * FROM `xcy_category` WHERE `pid` = 2 AND `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC,`id` ASC [ RunTime:0.000236s ]
SELECT * FROM `xcy_category` WHERE `pid` = 3 AND `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC,`id` ASC [ RunTime:0.000282s ]
SELECT * FROM `xcy_category` WHERE `pid` = 4 AND `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC,`id` ASC [ RunTime:0.000319s ]
SELECT * FROM `xcy_category` WHERE `pid` = 5 AND `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC,`id` ASC [ RunTime:0.000234s ]
SHOW FULL COLUMNS FROM `xcy_brand` [ RunTime:0.003184s ]
SELECT * FROM `xcy_brand` WHERE `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC [ RunTime:0.000689s ]
SELECT * FROM `xcy_category` WHERE `status` = '1' AND `pid` = 0 AND `type` = 'download' AND `lang` = 'cn' LIMIT 1 [ RunTime:0.001655s ]
SELECT * FROM `xcy_category` WHERE `status` = '1' AND `pid` = 0 AND `type` = 'download' AND `lang` = 'cn' LIMIT 1 [ RunTime:0.001801s ]
SELECT * FROM `xcy_category` WHERE `pid` = 39 AND `type` = 'download' AND `status` = '1' AND `lang` = 'cn' ORDER BY `sort` ASC,`addtime` ASC [ RunTime:0.001544s ]
SELECT * FROM `xcy_category` WHERE `status` = '1' AND `id` = 40 AND `type` = 'download' AND `lang` = 'cn' LIMIT 1 [ RunTime:0.000310s ]
SHOW FULL COLUMNS FROM `xcy_download` [ RunTime:0.000904s ]
SELECT COUNT(*) AS think_count FROM `xcy_download` `a` LEFT JOIN `xcy_category` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`lang` = 'cn' AND `a`.`pid` = '40' AND `a`.`addtime` <= '2025-03-14 21:31:13' [ RunTime:0.001933s ]
SELECT `a`.*,`b`.`name` FROM `xcy_download` `a` LEFT JOIN `xcy_category` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`lang` = 'cn' AND `a`.`pid` = '40' AND `a`.`addtime` <= '2025-03-14 21:31:13' ORDER BY `a`.`sort` DESC,`a`.`addtime` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.001132s ]