SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84180 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84180 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115185,909999,967029,1000040,834641,710935,432866,422236,221948,375424,612459,152972,570676,1016858,883748,786628,997982,684217,863911,737939,427923,38709,820625,509298,951664,308472,443971,159368,43898,95092,385307,162673,262393,773131,9518,504234,771692,236939,773803,796167,13951,840710,301270,594978,488779,178667,965046,736333,531041,102779,854004,165658,914480,39339,134386,75718,469562,780083,136661,563992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001186s ]