SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 880322 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 880322 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521483,864966,444495,720460,225900,328336,115788,905378,662249,1032782,979024,389750,964687,392183,32621,1003410,348173,427378,998186,75727,249447,861190,916223,820337,104680,920436,894375,797599,211419,445157,871751,1027319,445124,244723,112210,984914,389686,489909,258215,144818,560945,474368,73365,158582,319247,395767,364041,960842,188427,491928,629165,636669,1000319,482608,147768,391121,686625,59923,213618,1040663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 880322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 880322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]