SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499099 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499099 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59652,680480,192597,1019598,343685,49412,728930,658682,606765,296229,609370,60418,1031021,368245,1031783,284237,80249,274184,755788,57534,834998,666037,12667,407050,1028531,1033602,290943,550851,325625,227768,711929,992084,300807,827726,221887,36515,1010691,35110,773568,30113,699793,505758,57049,607610,929420,787654,1036946,97733,674555,364869,602930,718145,545835,992135,788393,552918,1013655,813796,556968,352238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]