SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101897 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101897 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789003,1043318,688514,769472,979430,115868,1031363,404474,883158,697387,33033,585686,546468,790454,422929,717468,251548,839666,257149,857451,245342,46996,14530,994110,435404,621932,673983,71631,540380,847406,10594,182139,289907,259003,394016,601681,964531,988624,752260,167847,285267,914828,803854,222164,122520,615668,139262,586264,994098,10865,374544,534343,343790,190708,820934,164310,4347,91477,903415,719348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]