SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10568 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10568 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413279,546289,396054,671347,333773,221592,554046,770576,151566,574432,195747,217871,531979,4715,927567,824066,613575,754376,153642,495886,695973,330445,716535,333793,57610,232737,52835,459038,922474,792717,706704,276857,482225,1007563,429250,352125,717992,173362,600722,700109,857568,557074,281252,587888,83020,791428,759225,198068,363607,65130,217500,703665,559408,77055,146800,712082,912364,456081,653687,707413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]