SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415247 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415247 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199150,1029567,786352,754722,236016,288208,476811,535968,312,323751,1972,421074,156826,434909,266156,497087,143676,1007645,933378,561133,569531,507545,827460,917314,678435,526439,854189,392318,335011,496209,502609,915837,794585,253004,614808,665467,1014341,789751,729304,334657,761508,201866,12126,790005,472459,222150,748772,550419,450280,358532,965663,497083,719924,130477,307092,803902,507849,590282,2550,857262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]