SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 125581 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 125581 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327271,125275,550744,164417,786665,337948,490113,575173,264698,505918,261469,698001,652087,803239,637615,946015,747991,8591,712952,173012,238440,921295,311081,453835,343193,964741,648262,552216,171277,561481,256190,1028772,586024,1001033,867473,299382,330705,882383,277614,359750,782779,117739,873454,714195,901825,740889,962228,702614,402495,898100,1030599,593716,81758,548788,518478,422283,38419,39930,558661,760083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 125581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 125581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]