SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528086 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528086 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105739,509734,378414,208349,236957,597585,647310,889584,772220,979710,571666,831509,685215,102638,581611,94558,634512,851189,15505,97157,907121,133173,766720,717100,716024,195754,648058,750752,265668,919831,832031,306415,937944,785337,793930,1030499,63295,206702,542745,230590,947907,117012,776913,364074,289023,816277,303945,976338,629559,871042,289828,548085,391030,516475,148740,93290,641333,478902,566026,709777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]