SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344251 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344251 [ RunTime:0.002819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199096,175304,325441,5513,680818,919029,781190,50908,485740,185262,993534,565846,686396,447181,780032,315942,840642,134436,65018,95740,720303,34619,7811,319,163143,1009628,104654,237239,80064,703701,1042747,740525,311939,893067,43059,304822,421364,416108,897246,104488,908472,44251,479404,745700,67251,941077,516673,25555,1030858,348786,772066,12538,128191,760861,51433,796297,13869,45160,626969,414969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]