SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104512 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104512 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629258,799562,635256,596608,686506,846593,1039685,446223,69776,845822,412334,118855,627410,188573,949426,524078,981627,39883,172381,737319,759776,1040808,203233,529851,77407,393220,467925,797258,826951,409193,123488,94734,697723,89138,847693,98082,290015,389090,650133,372723,246102,1041595,526512,117696,530265,747207,956072,341891,831712,214620,349639,124316,158608,419694,994434,797550,938618,970441,1037209,391196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]