SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454580 LIMIT 1 [ RunTime:0.001012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454580 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144981,599221,711880,812033,745093,355726,690444,12782,338905,705104,213310,240915,451429,649396,714716,584864,144023,560333,403375,985884,275673,785559,295636,40063,1041937,189974,494845,821226,439219,301008,517778,87801,444359,259775,862326,837441,942252,758575,623065,760803,467834,323966,694064,846511,220981,138793,755504,370381,572753,175242,84697,215166,854632,744523,829699,711823,339169,364923,637168,440979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]