SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28099 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28099 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174060,1003583,805049,463961,834944,677109,533510,469042,1026646,920372,44042,280404,874496,453852,821035,262913,17554,1035697,223955,171276,788217,112213,851991,668922,381506,817779,507326,228165,12527,483365,342890,609996,629717,1007316,249747,969426,196663,469070,464906,95695,917406,585010,329406,435771,74220,564430,61857,998586,994179,989148,691795,610877,982551,1031870,492869,538336,972303,626432,338414,309600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003180s ]