SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001502 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001502 [ RunTime:0.004432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585149,412806,410154,554709,905700,921495,182045,490873,447234,572489,689624,922291,12230,213791,104702,43467,749444,4992,76759,1027647,648530,863851,523568,533187,182014,169056,638542,283242,227883,521261,172708,535795,748635,125192,703612,551043,384648,355196,68353,198431,817655,752339,336568,754095,1017822,986328,475435,1045450,163316,455140,191590,149583,436952,610281,107540,127212,768888,659604,686391,722214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]