SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45004 LIMIT 1 [ RunTime:0.001450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45004 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432558,348845,656409,325180,137254,527985,573361,179848,210186,144999,565019,248732,392565,214228,872399,705083,670269,284752,844808,1006649,975379,752394,861686,436177,504427,635230,46990,511897,237456,844464,464998,1021608,317454,136256,676204,118666,662799,654955,781360,83961,451408,270430,504388,878720,982914,396879,11204,859142,350236,802392,526504,758019,840671,260863,141121,739175,1031130,408590,829734,364572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]