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` = 332313 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332313 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8248,760308,165425,95212,342307,427446,659505,408611,973736,84944,483289,342414,970820,107692,488522,466517,187575,50975,465469,178141,472692,125371,796290,297149,885961,160215,386553,475410,498324,371859,539630,956944,264974,432201,372177,949915,788389,428721,36895,10039,144390,265645,632329,267337,656536,60973,750816,444804,34278,616317,934836,487838,931372,749744,214683,679727,265669,468208,306419,304465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]