SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995048 LIMIT 1 [ RunTime:0.001406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995048 [ RunTime:0.003752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399214,578339,1044352,596358,561682,917936,507014,998321,604046,24020,840015,544861,473546,450589,1020094,864896,769647,180585,96837,310852,110669,605939,828680,338207,779699,117628,61787,65517,136946,755862,448831,349588,188975,502844,507572,959107,479475,25200,785110,710920,859058,1018362,981945,394023,1410,729543,103615,978658,470770,550765,612508,72810,324333,729946,474055,523988,447490,511553,360415,1032205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001254s ]