SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515714 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515714 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480287,486397,21957,225285,488433,668663,698606,987026,75844,295654,741734,324799,617332,230513,707204,199986,80676,579483,555548,819269,696895,895429,569591,857139,619542,85379,592967,605226,613855,287973,590106,554491,234255,185829,847741,52491,489670,389326,151609,590351,165140,729893,104871,637017,97041,470557,1001830,425672,825025,615692,586243,433727,13015,976611,531794,661171,147207,678172,433901,354953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]