SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320012 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320012 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19926,410986,204985,703879,418921,924485,905366,150199,201043,518872,519593,510163,882994,644755,101050,408428,950997,147439,671293,1008897,352191,394875,44989,906075,994710,682537,331756,123637,819510,922848,308925,488204,444871,303519,865297,927132,145452,634285,574771,404119,727489,72538,980118,556722,629146,726367,270324,987073,435251,289781,863938,373272,108313,786064,606956,86799,760802,143098,47034,381946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]