SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455420 LIMIT 1 [ RunTime:0.000726s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455420 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737212,163196,156967,325881,165765,607971,704092,680944,785430,295904,918050,287324,789479,513173,647708,12243,905712,702739,978997,279900,53772,461924,886224,351536,76645,26183,607031,38159,933306,365864,626973,478263,595031,897614,1047493,904163,932853,672121,499440,590756,394733,340455,412611,772392,961697,206501,651396,193226,270780,806804,705975,407608,933315,121402,435067,787997,301387,30388,265839,422478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]