SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438062 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438062 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561599,665781,88188,461486,308620,75533,173395,137716,212173,1013313,536187,611331,145689,74834,221753,200015,389722,655174,532824,798109,986516,722604,81397,655576,283599,673677,63023,115621,401734,919769,280694,457740,653767,11811,300045,147719,968203,429986,794801,258814,286447,226701,424982,995636,647554,415985,77878,506256,685451,54502,90017,70078,149345,670141,241101,857592,538385,366048,93639,272037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]