SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450336 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450336 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986918,231560,853444,174776,1035247,634455,711850,115172,639892,162636,414820,1014846,271173,933479,311133,417578,497537,815343,28779,136035,905453,478537,596688,911135,236492,933404,126831,578690,156142,137515,112265,842770,678853,810277,137520,153690,631346,533331,865315,283594,262093,841725,845541,1001522,527990,249412,99664,848221,720513,179484,752871,684206,887860,206940,256352,46015,100229,539276,185848,721031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]