SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674813 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674813 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64454,474995,915233,48664,468778,72042,210766,50559,837906,887332,834695,930497,556800,450779,326307,16946,194777,168411,88729,561855,194654,682200,897341,42385,432897,603464,924053,696962,433052,320636,217640,224637,1012413,947041,619845,1038345,356891,912583,934854,122178,590825,666318,742390,1015142,174584,924243,1008810,146002,404584,659247,971100,692166,389837,1019658,954590,120138,537426,870771,575498,271883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]