SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046943 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046943 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457836,195885,750166,342929,754951,752423,191758,731706,288839,342222,972320,804164,715162,110040,995733,532135,738947,544567,341786,893192,25700,236421,964498,362506,1035506,514303,84457,479300,756587,644803,545069,881823,586067,35917,915342,906380,19161,641290,353034,64236,500602,628774,19884,772905,466850,290935,73829,587328,50211,1030719,451189,291238,175808,348469,656295,704108,676167,703195,119342,870429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]