SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449401 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449401 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982767,497858,963743,76883,524526,837384,538639,200258,210040,1662,914292,764229,732900,885370,809178,767677,859104,76534,880004,315739,249740,404128,286812,776749,241649,944327,833974,96431,497264,565853,630217,739567,823991,657327,452669,284990,204891,518546,1058,42725,299652,342778,971887,989333,614196,537607,313535,451778,408295,904662,631527,744795,737944,989966,705372,713220,965135,928250,41246,730923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001547s ]