SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002851s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406583 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406583 [ RunTime:0.006710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575662,133961,340675,967830,650987,230509,973430,72478,789541,712083,509667,318292,925813,420712,313714,370416,104979,408216,462971,906585,1032066,681905,247628,563655,487740,388361,52612,724739,1025832,426297,128791,778769,589794,46858,183476,803105,219247,259745,365653,483748,821401,734153,899006,15989,341650,494553,529597,432424,162119,88423,909816,496317,629031,985460,75074,601180,335916,647629,581914,9242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]