SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541354 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541354 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20990,41569,860490,224289,8955,851806,72065,743014,533941,814779,415586,464133,320553,726206,935744,408016,284051,900284,613087,528675,584759,572465,903122,380830,378118,436873,475569,997399,83964,150464,242309,71240,28828,1026885,158502,44145,224019,284972,903694,843547,133645,259814,1031813,32042,231852,584512,475355,22921,304723,513530,723287,645374,331401,17500,696473,247041,598157,165262,111987,1018624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]