SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461721 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461721 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60110,817252,547950,7244,686837,422303,622924,914653,962894,1044500,643814,248201,814563,120317,378217,47051,1008218,502811,747596,810801,317129,325769,756296,847084,829646,334889,59398,164064,765246,98625,71948,630073,212963,315089,203310,995818,1036751,775991,96903,382590,251651,405070,380819,430680,507302,887390,54617,516681,447915,761381,399762,570209,979171,441763,835725,330905,16377,819137,989624,693805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]