SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411560 LIMIT 1 [ RunTime:0.000749s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411560 [ RunTime:0.007195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817267,956643,1025278,876275,162988,859241,791582,555954,975942,572871,17866,518818,307204,191663,466129,679265,735668,410623,237390,258604,244454,642456,581995,515274,279242,661087,288958,867930,340669,199688,653121,611945,314102,88248,445749,706836,690516,756632,567579,575785,701198,1014743,519019,857939,929418,168396,631872,604418,503935,665036,336141,693532,554074,506142,244542,986494,105705,858257,815080,143031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000866s ]