SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413612 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413612 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525164,456363,61595,904163,872841,707241,455162,1008254,77741,1047717,114165,531309,433457,476822,122676,334995,728028,864818,94894,185290,172856,145641,906136,284395,641510,1017626,161100,327336,620083,523485,761051,692810,451937,827425,936703,683679,288096,1020174,297954,94532,719926,653987,644688,288846,554505,134609,827987,857913,1001338,353625,670439,363049,325187,606315,768158,372340,612663,709398,105996,555303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]