SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317245 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317245 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707068,372751,548316,284129,406547,80807,10020,770798,1006151,92637,260016,282270,357946,740148,471037,181295,835009,408139,737961,853473,613248,473614,1008279,829777,427881,839500,76479,685192,545534,818875,833867,397982,231485,1035307,93479,451944,738153,840653,690387,333030,346824,952144,588080,196172,758715,140825,400825,274510,438677,113064,1001431,481719,840706,534518,508319,900922,242871,186483,892278,314595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]