SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349804 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349804 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428815,396966,725310,129257,196052,697249,291373,385852,323418,243720,703628,83568,772480,497853,152181,793806,152669,1032097,126626,978805,208744,135319,202468,660711,701067,441155,463561,941487,95891,204965,221077,333563,521058,22454,714948,743152,259094,1021180,614282,325082,682644,820797,917596,982269,785685,163488,232430,627245,958082,16789,319928,411733,215049,617626,42151,508499,991592,78164,189221,342145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]