SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016887 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016887 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400639,911404,467074,830992,892664,601930,89924,223542,613808,570112,467340,560249,304471,977114,429374,78123,613134,772228,663535,732465,293882,691006,83039,619603,630966,831771,643615,326538,532813,210581,1007617,283645,1012416,994062,836631,108852,334426,221903,541073,57676,267652,587908,179151,1044696,43372,821993,298221,316900,801570,548543,360161,147050,998549,399352,483918,285583,825368,394073,538684,851108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]