SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519501 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519501 [ RunTime:0.002631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75272,963940,396776,4196,128559,208900,368892,1002876,675478,452472,601580,553602,1060,537967,1037338,158293,325466,647800,813721,78114,423658,1004637,495035,965228,879801,750653,273203,592306,330230,681663,460745,198231,477626,470626,25703,665918,1038867,316145,537260,614303,834296,1018928,465173,1032596,160844,705246,419780,881757,550690,211187,938446,651688,8655,686931,451890,159182,734192,156457,145351,571243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]