SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553929 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553929 [ RunTime:0.003475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433701,1007541,369020,606767,257237,710113,490102,979178,633425,281521,108414,749316,976870,41805,722531,836085,541967,486640,347160,303421,803369,964552,413620,371920,769272,219428,378315,373456,111184,905802,808512,966055,60864,894477,718016,287110,234640,298426,776492,100606,464834,599541,228762,718462,89246,115961,731942,497212,552166,841367,1012512,584550,762963,138016,357851,647799,545616,82997,1001263,294248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000809s ]