SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297504 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297504 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261544,952322,855543,11613,839419,756418,924525,200754,1017891,93240,125140,516397,278402,716448,337985,603513,396177,242895,640952,648736,828872,47842,974376,488551,620769,785053,124880,785438,983002,502221,296200,830373,794299,387061,150855,413548,61043,202624,821125,285917,813574,478810,129171,722269,67722,610585,797515,283251,736461,6095,229543,994765,328383,128715,698293,458021,976815,64672,330023,621576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]