SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535299 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535299 [ RunTime:0.003265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590214,204641,529522,285877,229385,378500,835513,277006,351541,78287,393828,399842,723518,768969,765383,800739,243302,225408,584756,774157,362170,653778,448182,336210,643427,587568,696183,739801,42454,1042520,90844,691360,756687,677821,155360,266278,284084,133897,72617,1030751,198773,77232,73216,125797,451926,405870,396176,987914,975096,591449,950729,440072,380599,987353,147688,732559,296681,299543,479054,391926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]