SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418791 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418791 [ RunTime:0.003388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018376,492209,809613,953839,631942,43896,278385,465349,628141,336315,690710,307000,637852,677285,737980,279934,554346,626785,160506,983321,178815,432053,323980,1025511,772293,839996,621873,343662,1040819,824569,640784,728371,671781,576292,1027376,181913,1037865,860117,441841,478953,857725,62472,272295,368085,616973,918920,447704,107224,22929,774295,1047734,789342,897539,610187,512041,999133,327164,1038227,1039923,739625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]