SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14914 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14914 [ RunTime:0.002871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197964,528917,366143,1009293,611126,757103,41921,734780,904806,71465,564738,423060,517025,383041,41008,214099,757513,274423,1042968,462152,458967,195369,78168,536397,510468,144972,574383,268048,1033923,398006,576950,3752,484456,14692,175003,1035180,314254,175904,1002942,439455,138449,888122,148984,574057,837882,247275,662513,1045830,146853,831352,428844,980992,586670,464492,527698,109509,253182,253744,603994,856125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]