SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320822 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320822 [ RunTime:0.002672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258838,994198,161372,319391,454527,828076,347992,947194,112162,1044875,115906,307623,144116,986046,765343,367318,514783,602358,490288,336396,311034,508474,546131,634959,1041013,170204,434430,626982,655893,475000,638241,39559,268093,465040,93243,632362,480640,976337,179161,280179,419787,831271,405845,398142,517703,873744,436886,236199,775674,200012,294527,147814,709364,848075,516871,41554,633548,75958,206234,817417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]